Naming the Series
 

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

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