Axis values

  • Thread starter Thread starter Sri Harsha
  • Start date Start date
S

Sri Harsha

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?
 
Right click on the axis, choose Format, then adjust the axis scale yourself.

- Jon
 
Back
Top