scatter chart graphs

  • Thread starter Thread starter LIZ K
  • Start date Start date
L

LIZ K

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?
 
Liz,

You can add these variables with VBA. You are changing the xValues and
Values properties of the graph after adding a newSeries.
 
Back
Top