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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding data series to chart via macro
That line of code should be fine. You didn't share with us the code leading
up to it, the error description, the value of N, the number of series in the chart (did you make sure you have at least N series?), the data in the source data range. There are some VBA-Chart code examples on this web page which you may find helpful: http://peltiertech.com/Excel/ChartsH...kChartVBA.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "JessK" wrote in message ... 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? |
Reply |
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 |