Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2003

Tip: Looking for answers? Try searching our database.

Wrong numbers on axes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert Chapman - 03 Nov 2003 08:14 GMT
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 - 03 Nov 2003 14:42 GMT
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/

Signature

Regards,

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

> I have encountered some strange numbering problems on
> graphs in a number of my files.  The x axis time values:
[quoted text clipped - 16 lines]
>
> TIA, Rob
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.