I want to get a visual quot;apples to applesquot; effect in my charts. However,
Excel doesn't seem to offer a way to quot;normalizequot; the y axis (that's the
vertical axis, right?). If the data in the range goes from .01% to .88%
for one data set and from 1% to 7% for another data set, Excel changes
the y axis accordingly, which displays the illusion that the resulting
charts are not much different from one another. I would prefer to take
the highest data range (7% in this example) and the lowest (.01% in
this example) and apply that as the y axis for both charts, so that the
user would get a visual sense of the real relationship of one dataset to
the other,
Any suggestions would be appreciated.
Thanks,
Bill--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: www.excelforum.com/member.php...oamp;userid=25838
View this thread: www.excelforum.com/showthread...hreadid=526096If you plot both data sets on the same chart on the same axis, XL will
automatically adjust the scale to accomodate both series.
If you have separate charts (or plot the 2 series on primary/secondary
axes), you can manually adjust the min./max. values by double-clicking the
axis and then selecting the Scale tab.
You can automate the above by pseudo-linking the parameters to cell values
with
AutoChart Manager
www.tushar-mehta.com/excel/so...art/index.html
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article gt;,says...
gt;
gt; I want to get a visual quot;apples to applesquot; effect in my charts. However,
gt; Excel doesn't seem to offer a way to quot;normalizequot; the y axis (that's the
gt; vertical axis, right?). If the data in the range goes from .01% to .88%
gt; for one data set and from 1% to 7% for another data set, Excel changes
gt; the y axis accordingly, which displays the illusion that the resulting
gt; charts are not much different from one another. I would prefer to take
gt; the highest data range (7% in this example) and the lowest (.01% in
gt; this example) and apply that as the y axis for both charts, so that the
gt; user would get a visual sense of the real relationship of one dataset to
gt; the other,
gt; Any suggestions would be appreciated.
gt;
gt; Thanks,
gt;
gt; Bill
gt;
gt;
gt; --
gt; ragtopcaddy
gt; ------------------------------------------------------------------------
gt; ragtopcaddy's Profile: www.excelforum.com/member.php...oamp;userid=25838
gt; View this thread: www.excelforum.com/showthread...hreadid=526096
gt;
gt;
Nevermind, I found it (obviously!). How I managed to get 2 copies of the
same post on this board is mysterious!--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: www.excelforum.com/member.php...oamp;userid=25838
View this thread: www.excelforum.com/showthread...hreadid=526096
