LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Needing to re-order a datatable display on an Excel chart Poody Charts and Charting in Excel 0 April 11th 06 01:40 PM
Can we generate excel chart with out opening the excel instance.? ramkumar_cpt Charts and Charting in Excel 0 March 29th 06 11:46 AM
Distorted Excel chart fonts when copy/paste to Word or Powerpoint JJMB Charts and Charting in Excel 2 March 18th 06 06:43 PM
Chart disappears in Excel 2000 [email protected] Excel Discussion (Misc queries) 0 November 8th 05 04:42 PM
Using Microsoft Excel Chart object in VB6 fizbim Charts and Charting in Excel 0 July 13th 05 05:14 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"