Capture the legend title. Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I create a macro for chart creation and have inputbox for X axis and YAxis
titles. Now in the legend, It shows "Series 1", "Series 2". Is there a way
to change it to the user's input?

Thank
le9569
 
Hi,

You need to change the Name property of the series, so something like,

Activechart.SeriesCollection(1).name="My Seriesname"

Cheers
Andy
 
Back
Top