| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming the Series
Hi,
To set the name of the chart series use something like this, ActiveChart.SeriesCollection(1).Name="My name" ' or cell reference ActiveChart.SeriesCollection(1).Name=Range("Sheet1 !A1") Cheers Andy Joe wrote: Hi, Thank you all for the continuous support/clarifications. I have an excel chart/graph which gets dynamically gets updated using the VB macro. I have 5 series in the in the chart and they are named with the meaningfully in the chart template. But when I run the macro to update the chart with the new set of values the names of the series are set to Series1, Series2 etc. How do I prevent resetting of the series names? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart series | Charts and Charting in Excel | |||
| Trying to change ColorIndex for series settings | Charts and Charting in Excel | |||
| Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
Threaded Mode
