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
 

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

Similar Threads

Make Y-axis values correspond to x- axis value 1
Stacked column chart narrow bars wanted 5
Make a mekko chart in Excel 2007 in three easy Steps 1
Zero length string on chart 1
X Axis Linear Representation Problem 6
Move Data Series Manually 4
Delete selected major gridlines in a chart 1
How do I make x-axis dates in area chart not start from/drop to ze 5

Back
Top