Excel 2003 charts not plotting accurately

DallasGirl

New Member
Joined
Dec 30, 2009
Messages
4
I have two Excel charts not plotting accurately. In one simple line chart, we have one data point that should be around 350 but it shot up to 784. (X axis was a short series of dates, with a 1:1 plotting ratio) All the rest of the numbers plotted fine.ᅠ
And today, in a completly different and unrelated file and data set - this one is a scatter chart. I have one point that should plot at 350, 1708 (x,y) but it shows at 280,1708; and another point that should be at 723, 3000 but is displaying at 760, 2300. There are 150 points and to physically check each one is painful. I have not been able to find anything relevant in the M$ KB.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,108,938
Messages
5,525,734
Members
409,661
Latest member
pprabha

This Week's Hot Topics

Top