sstairs
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.
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
Here is the direct link
https://filedb.experts-exchange.com/incoming/ee-stuff/3021-401-k--Match-Tracking-2.zip
https://filedb.experts-exchange.com/incoming/ee-stuff/3021-401-k--Match-Tracking-2.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Rory
Can you post a copy of the workbook (censored if necessary) at www.ee-stuff.com?
Regards,
Rory