How to prevent Names of the Series being reset
 

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