Axis values
 

Hi,
I am trying to generate a chart through a pivot table and by default, it is
taking 20% difference in vertical values data in the axis like 0%, 20%, 40%
etc. If my value is 87.50%, the marker is pointed above 100%. This happened
to only "Stacked line with markers" and it took 10% difference in values for
other ones and they look fine. How do have excel change the values it takes?

Axis values
 

Right click on the axis, choose Format, then adjust the axis scale yourself.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Sri Harsha" wrote in message
...
Hi,
I am trying to generate a chart through a pivot table and by default, it
is
taking 20% difference in vertical values data in the axis like 0%, 20%,
40%
etc. If my value is 87.50%, the marker is pointed above 100%. This
happened
to only "Stacked line with markers" and it took 10% difference in values
for
other ones and they look fine. How do have excel change the values it
takes?