updating a chart series automatically
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! |
updating a chart series automatically
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! |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com