If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Values plotted incorrectly on Line Chart
Hard to solve without seeking the problem. Email me (remove TRUENORTH. ) a
copy of you workbook file best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lori H." Lori wrote in message ... 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 |
#3
|
|||
|
|||
Values plotted incorrectly on Line Chart
Thanks, but your email isn't shown.
(I'm hoping it will show in the history part of this reply) "Bernard Liengme" wrote: Hard to solve without seeking the problem. Email me (remove TRUENORTH. ) a copy of you workbook file best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lori H." Lori wrote in message ... 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 |
#4
|
|||
|
|||
Values plotted incorrectly on Line Chart
Problem solved. A stacked line chart was inadvertently made when a simple
line chart was required -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lori H." Lori wrote in message ... 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 | |
Display Modes | |
|
|