• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

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.
0
sstairs
Asked:
sstairs
  • 3
  • 3
1 Solution
 
Rory ArchibaldCommented:
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
0
 
sstairsAuthor Commented:
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.
0
 
sstairsAuthor Commented:
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rory ArchibaldCommented:
Ah, you are using the EOMonth function, which requires the Analysis toolpak add-in to be loaded. You will either need to make sure that all your users have it loaded or adjust the date functions in row 3 to read (for D3):
=DATE(YEAR(C3),MONTH(C3)+2,0)
and copy it across to N3.
HTH
Rory
0
 
sstairsAuthor Commented:
Geez, I love this site. Right on the mark. I never even thought about that. Thanks for the lesson rorya.
0
 
Rory ArchibaldCommented:
Glad to help and thanks for the grade.
Rory
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now