scatter chart graphs
 

I am trying to graph the delivery of pipes for a pipeline.
Y being date of delivery, x axis showing mile post.
data is to show a line the length of pipe delivered, beginning at the mile
post it is to be laid and ending at the length it is.
I have various pipe length and widths. Data Source option only allows me to
enter each individually. Is there an easier way of entering the Data into the
graph?

scatter chart graphs
 

Liz,

You can add these variables with VBA. You are changing the xValues and
Values properties of the graph after adding a newSeries.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"LIZ K" wrote:

I am trying to graph the delivery of pipes for a pipeline.
Y being date of delivery, x axis showing mile post.
data is to show a line the length of pipe delivered, beginning at the mile
post it is to be laid and ending at the length it is.
I have various pipe length and widths. Data Source option only allows me to
enter each individually. Is there an easier way of entering the Data into the
graph?