Thread
:
Normalizing the y axis
View Single Post
#
2
Posted to microsoft.public.excel.charting
Tushar Mehta
Posts: n/a
Normalizing the y axis
See the response to your other post on the same subject.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I want to get a visual "apples to apples" effect in my charts. However,
Excel doesn't seem to offer a way to "normalize" 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:
http://www.excelforum.com/member.php...o&userid=25838
View this thread:
http://www.excelforum.com/showthread...hreadid=526097
Reply With Quote