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.

 

[han_solo]

hi, can have a look at it if you send me the file (or an example of a file that displays the same problem).

Trust me and i'll get back to you soon

 

[Philip Perfect]

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.

 

[namnoc]

Dear Mr Perfect, how dare you say that before I could

 

[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

 

[Philip Perfect]

No problem