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!

Take a look he

http://peltiertech.com/Excel/Charts/Dynamics.html

In article ,
"KyWilde" wrote:

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!