Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding data series to chart via macro
I have a macro that adds rows of data to a summary table. I would like to
update my chart by adding a new series for each new row of data, but the ActiveChart.SeriesCollection(N) command will not accept a variable for N. for example, the command will add Data series # 3 with N=3, but if I create a variable "run_num" set equal to the # of the current data series (ie, run_num = Range("A5").Value), then the command does not work. How can this be done so that the added series increments each time the macro adds a new row of data? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Pivot Chart - X,Y & Data Series Options | Charts and Charting in Excel | |||
Transparent Chart Data Series | Excel Discussion (Misc queries) | |||
Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |