How to prevent Names of the Series being reset

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming the Series 1
Excel macros graphs work on one laptop, but do not on another. Wh 1
how to keep the oiginal format of charts intact in excel vba afterdeleting a series ?? 1
How to change Series Order in a Combination Chart? 0
syntax to concatenate two named ranges? 2
Dynamic series in rows 1
How to chart data like this? 0
One extra x axis item that wont go away - can anyone help? 3

Top