Normalizing the y axis

  • Thread starter Thread starter ragtopcaddy
  • Start date Start date
R

ragtopcaddy

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
 
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
 
I'm not aware that I have another post on the same subject. I haven't
posted here for some time, and I don't recollect ever asking a similar
question regarding charts.
Could you please provide a link to this other post?

Thanks,

Bill R
 
Back
Top