Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting straight line
I am trying to plot several values on a straight line for a few dates.
06/01/2007 -------10--------18--20----------------42 06/05/2007 --4-----11-----17-----------30-----38 I can create a chart with clusters of bars for each date with each bar stretching to the X value that represents the plot number but have not been able to figure out how to plot a straight line with the X value data points. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting straight line
I knew what you wanted until I looked at the data. In general to get a line,
you need X values (in your case, dates) and Y values in adjacent columns. Select the data and make an XY chart. If the X and Y values follow a linear relationship, you will get a line on the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Lepercan" wrote in message ... I am trying to plot several values on a straight line for a few dates. 06/01/2007 -------10--------18--20----------------42 06/05/2007 --4-----11-----17-----------30-----38 I can create a chart with clusters of bars for each date with each bar stretching to the X value that represents the plot number but have not been able to figure out how to plot a straight line with the X value data points. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
straight line equation | Excel Worksheet Functions | |||
straight line graph, really straight line.. | Excel Discussion (Misc queries) | |||
best fit straight line | Charts and Charting in Excel | |||
best straight line in Excel | Charts and Charting in Excel | |||
Straight Line Graph | Charts and Charting in Excel |