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.
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.