updating a chart series automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to update a number of chart's series automatically. Basically on the
spreadsheet that the chart's information is on, a new line of information is
added and that new row needs to be added to each chart's series. How can I
do this dynamically?
ie.
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection(1).XValues = "=dvt_data!R3C1:R901C1"
ActiveChart.SeriesCollection(1).Values = "=dvt_data!R3C10:R901C10"
ActiveChart.SeriesCollection(2).XValues = "=dvt_data!R3C1:R901C1"
ActiveChart.SeriesCollection(2).Values = "=dvt_data!R3C11:R901C11"

so it's just the second R that needs to go from 901 to 902, then from 902 to
903 when each of these rows are filled (one per day).

Thanks!
 
Back
Top