Scale on line graph

G

Guest

I have two line graphs produced, from this data:

1 0 0
2 3 1
3 2 3
4 0 1
5 0 0

I want the Y-Axis to show the scale of 0-5 just like what i have done on the
first column. BUT it shows scale of 0, 0.5, 1, 1.5, 2, 2.5, 3, 3.5

Please help
 
A

Andy Pope

Hi,

Double click the Y axis and set the scales Major Step to 1 rather than 0.5

Cheers
Andy
 

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
Sliding scale for Mark Up 0
Constant % on X axis 2
Axis labels offset from grid line 0
## Charts: (non-)fixed scale ## 3
Values on 'y' axis - columm chart type 1
How do I draw a graph in Excel 4
Problem with Excel 2007 clustered column chart on log scale 1

Top