Naming the Series

[Joe]

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]

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