Plotting straight line

G

Guest

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd chart type needed 2
Scatter Plot: Change X-Axis Date 6
Chart adds in extra date values on the X axis 6
Charts When There Are No Data Values Sometimes ? 1
Charting scientific data - Excel 2003 5
date axis 7
Date/Time on X axis 3
How do I change the order of the line versus the marker for a scat 4

Top