Excel Graph Issue Driving Me Nuts!

[JoeF1]

Hi Guys.

Been asked a question in the office and for the life of me i cannot figure it out.

The Y Axis is doubling up and i don't know why.

I have selected 2 columns which have the simple numbers from 1 - 4. Every other time i do this, it doesn't do it but for some reason it's hates me

Halp!

Im using 2003 & 2007.

 

[JoeF1]

It's probably because the graph is trying to show y-axis values of 0.5, 1.5 etc. - but you've got the number of decimal places for y-axis values set to none. Excel rounds all of the intermediate values up and gives this effect.

Thanks a lot.

This solved it