View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Two-Canucks
 
Posts: n/a
Default Excel Chart does not have correct value

I have a line charts using a Date column
and two Value columns.
For 24 cells, everything works OK. With
the 25th entry the line turns sharply down
and shows an incorrect value!! This happens
even when I leave the entry empty!! When
I continue filling in data as a test the chart is
again correct.


Monday, May 08, 2006 36780.63
Tuesday, May 09, 2006 36948.93
Thursday, May 11, 2006 36496.29

Last point on line shows: Thursday, May 11, 2006 $29842.71
instead of $36496.29

What could cause this?
Many thanks
--
Occasionally stumped