LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Values plotted incorrectly on Line Chart

Any idea what's causing this or how to fix it?
In a line chart showing multiple series plotted over time, many of the
points are plotted at the wrong level (wrong height along on the Y axis),
although the data value is correct (as shown in the "tool tip" when hovering
over the plotted point).

For example, here are consecutive values for 3 series:
9, 2, 3, 3, 2 plotted as: 14, 7, 4, 5, 4
4, 4, 1, 1, 1 plotted as: 5, 5, 1, 2, 2
0, 1, 0, 1, 1 plotted as: 1, 1, 0, 1, 1
 
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
I want to find the lowest point on the plotted line in a graph. Edwin Charts and Charting in Excel 4 November 22nd 08 03:39 PM
I need to change a series plotted as a bar/column to a line. john Charts and Charting in Excel 1 October 9th 07 03:51 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 15th 06 07:56 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 7th 06 09:27 AM
How do I stop plotted data from going to zero in a line chart? Dozier Charts and Charting in Excel 4 August 19th 05 07:11 PM


All times are GMT +1. The time now is 10:17 AM.

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"