Prev: Excel Chart
Next: how to creat dashboard
From: Jon Peltier on 20 Apr 2010 09:38
Format the axis not to show axis ticks and tick labels.

Add an XY series to produce pseudo-axis features:

Arbitrary Axis Scale
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 4/17/2010 11:52 AM, Alex wrote:
> Thank you for the reply. It's not necessarily the -2 that's offending me,
> it's the fact that the scale starts *counting* at -2. So we have something
> that goes -2, 3, 8, 13... etc instead of 0, 5, 10, 15. Yes, I could have it
> start at -5, but that gap is much large to look "nice". I was hoping that
> there was a way (VBA?) to have excel start counting at 0. Guess not. No
> worries, like you write, it's not really a big deal.
>
> Alex
>
> "PBezucha" wrote:
>
>> Some ideas:
>>
>> There is nothing simpler than using connecting line thicker then the border
>> lines of plot area; you can distinct also by means of different colors. There
>> can be problems with connecting line disappearing under zero borders, if you
>> select continuous line mode, but this phenomenon somehow distorts the overall
>> image anymore.
>>
>> If label -2 in your proposal is offending you, you can deck it with an empty
>> (white) textbox.
>>
>> Visualization of spectra serves usually only for obtaining a rough overview;
>> absolute values don't matter. So you can omit y-scale labeling at all. The
>> baseline at y=0 will be either self marked by plenty of zero values, as you
>> unwittingly notice, or you can draw a new y=0 line and mark it by a textbox
>> '0'.
>>
>> --
>> Petr Bezucha
>>
>>
>> "Alex" wrote:
>>
>>> Every once in a while I need to plot some spectral data. Because it's not
>>> very often and it's just simple plots, I can't justify to my boss the
>>> purchase of fancy and expensive plotting software programs (SigmaPlot,
>>> Origin, etc.). However, I can't figure out how to one thing in Excel:
>>>
>>> I have data with x being time and y being some value. Also, there are many
>>> points with y=0. I want to plot an xy scatter graph with a smoothed line
>>> connecting the points. However, because most points are at y=0, most of the
>>> plot is hidden by the x axis. Problem is solved if I set the y minimum at,
>>> say, -2 but then the axis numbering starts at -2 instead of 0. How can I set
>>> the minimum at -2 but have the numbering begin at 0?
First  |  Prev  | 
Pages: 1 2
Prev: Excel Chart
Next: how to creat dashboard