One Line Charts

[dianna]

I need to plot one line on a chart, not two, and I need it to start with my
data a 0 minutes and then go up at 30 second increments. For example, my
temperature at 0 is 37.9, then my data at 30 seconds is 71.2. So how do I
get my chart to show the values at 0 and 30 seconds? I was able to get it to
show those temperatures, but it plotted them starting at 1 minute, not 0.

 

[Jon Peltier]

I think the problem is that you are using a line chart and not an XY chart.
If the X axis has numerical data, you shouldn't use a line chart.

Despite the misleading names and the appearance of the icons in the Chart
Wizard, an XY chart can have lines connecting the points.

- Jon

 

[dianna]

Jon,

Thank you. That worked.

Dianna

I think the problem is that you are using a line chart and not an XY chart.
If the X axis has numerical data, you shouldn't use a line chart.

Despite the misleading names and the appearance of the icons in the Chart
Wizard, an XY chart can have lines connecting the points.

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