Wrong numbers on axes

[Robert Chapman]

I have encountered some strange numbering problems on
graphs in a number of my files. The x axis time values:

1 2 3 4 5 6 7 8 9 10 11 12 13 are appearing in some graphs
as
1 2 3 4 5 6 7 8 9 1 1 1 1

All the graphs's axes label source is the same set of
cells. Changing the cells to different ones makes no
difference, the difference seems to be in each graph's
settings. In some other graphs I am getting a similar
problem, the numbers 1-31 having the 20s appear as 2s.

Interestingly if the axes is formatted as a number to 2
decimal places (in the faulty graphs) you end up
with ...7.00, 8.00, 9.00, 10.0, 11.0, 12.0.

Any ideas?

TIA, Rob

 

[Tushar Mehta]

I could be wrong, but from what I remember, this was a problem with a
particular version of XL, and was fixed with a subsequent support
release.

You might want to check if there are any updates/patches/support
releases available for your version of XL. Visit
http://office.microsoft.com/officeupdate/

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions