Axis values

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?
 
J

Jon Peltier

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

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top