Error in data plot
 

HI - I have a very simple line chart based on the following data series:

Date Time Systolic Diastolic Heart Rate
11/1 20:00 170 105 65
11/1 22:00 165 100 67
12/2 20:00 140 80 70
12/2 21:00 150 85 74

The problem is that the chart produced by the data shows the Y axis scale
all wrong. For example, the first Heart rate value is plottted at ~340 going
by the Y axis scale. However the cursor rollover produces the correct value.
Further, the lines for Diastolic are ABOVE Systolic on the chart, and the
lines for Heart Rate are ABOVE Diastolic. Any suggestions would be most
appreciated.

Error in data plot
 

What sort of chart have you used? It sounds like you've used something like
"stacked column" or "stacked bar", where each series is shown added on to
the earlier series, so you are seeing 170 for systolic then another 105 puts
your diastolic point at 275, and an extra 65 for heart rate is 340. Look at
the different chart types & sub-types, and choose something appropriate
(perhaps clustered rather than stacked). If you are interested in the X
values (dates in your case) as values rather than category labels, it's
normally better to use XY chart (confusingly labelled as scatter, though you
can use lines rather than just points).
--
David Biddulph

"RjS, CISSP, CISA" wrote in message
...
HI - I have a very simple line chart based on the following data series:

Date Time Systolic Diastolic Heart Rate
11/1 20:00 170 105 65
11/1 22:00 165 100 67
12/2 20:00 140 80 70
12/2 21:00 150 85 74

The problem is that the chart produced by the data shows the Y axis scale
all wrong. For example, the first Heart rate value is plottted at ~340
going
by the Y axis scale. However the cursor rollover produces the correct
value.
Further, the lines for Diastolic are ABOVE Systolic on the chart, and the
lines for Heart Rate are ABOVE Diastolic. Any suggestions would be most
appreciated.

Error in data plot
 

Use an XY chart, and select a subtype with lines if you want to connect the
markers. You have selected the stacked line chart type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"RjS, CISSP, CISA" wrote in message
...
HI - I have a very simple line chart based on the following data series:

Date Time Systolic Diastolic Heart Rate
11/1 20:00 170 105 65
11/1 22:00 165 100 67
12/2 20:00 140 80 70
12/2 21:00 150 85 74

The problem is that the chart produced by the data shows the Y axis scale
all wrong. For example, the first Heart rate value is plottted at ~340
going
by the Y axis scale. However the cursor rollover produces the correct
value.
Further, the lines for Diastolic are ABOVE Systolic on the chart, and the
lines for Heart Rate are ABOVE Diastolic. Any suggestions would be most
appreciated.