View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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