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?