Link to home
Start Free TrialLog in
Avatar of sstairs
sstairsFlag for United States of America

asked on

Excel graph showing wrong data

I have plotted several months (Nov06-Oct07) of data and graphed it out. On my pc and several others, it opens correctly, but on several others, the dates start at 10/0/1900 and continue as 12/31/1903,12/31/1907, and so on. All the other dates start with 12/31 with different years. So instead of 1 year of data broken down monthly, I have 103 years of data broken down with 4 or 5 years  between. All pcs are running either office xp or 2003 with some of each working correctly and incorrectly. It appears that somehow the cells are being defaulted as time data instead of currency on a few pcs thus showing dates instead of currency ranges, and I don't know why.
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Do all PCs have the same regional settings in Control Panel?
Can you post a copy of the workbook (censored if necessary) at www.ee-stuff.com?
Regards,
Rory
Avatar of sstairs

ASKER

Everyone is in the same region, and the same office. They wouldn't know how to do anything except open the file, so they couldn't have changed any local settings by themselves. I have posted the file.
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sstairs

ASKER

Geez, I love this site. Right on the mark. I never even thought about that. Thanks for the lesson rorya.
Glad to help and thanks for the grade.
Rory