One Line Charts
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. |
One Line Charts
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 _______ "dianna" wrote in message ... 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. |
One Line Charts
Jon,
Thank you. That worked. Dianna "Jon Peltier" wrote: 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 _______ "dianna" wrote in message ... 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. |
All times are GMT +1. The time now is 11:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com