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
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
Le9569 wrote:
> 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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks