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.

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.