Scales on Charts.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

I created a chart but the scale on the Y axis increments by .5 (1 to 1.5 to 2
to 2.5 to 3 to 3.5)

How can I change it to increment by whole numbers, 1, 2, 3, 4, ,5, etc....
 
Right click on the axis and click Format Axis. Then on the Scale tab change
whatever is in Major unit to 1, then click OK.

Regards,

Tom
 

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

x-axis scaling 2
Y axis log scale flipping 0
setting scale on chart automatically 1
Horizontal axis to the bottom 1
How do I match values from cells to a list of info 1
Excel chart - great variation in values 1
Scale on line graph 1
Sliding scale for Mark Up 0

Back
Top