Scale on line graph
 

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

Scale on line graph
 

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"EasySite" wrote in message
...
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