updating a chart series automatically

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want VB to select data automatically to the end of the row 4
Bubble Chart 1
Chart Control 11
adding a data series to a chart with variable inputs. 2
Chart code 4
Update Chart Source Data 3
Macro to change chart references 10
Charts Having X Axis Scaled Using Calendar Weeks 4

Top