Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Charts - Is this possible? | Charts and Charting in Excel | |||
Line Charts - Is this possible? | Excel Worksheet Functions | |||
Line, xy charts | Charts and Charting in Excel | |||
Line Charts | New Users to Excel | |||
Bar and Line Charts | Charts and Charting in Excel |