Capture the legend title. Help

L

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
 
A

Andy Pope

Hi,

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

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

Cheers
Andy
 

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

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
legend problem in mixed line-scatter graph Excel 2007 0
How do I find the series associated with a given legend entry. 4
split legend 3
deleting legend keys in mixed line-scatter graph not correct 1
deleting specific legend keys in mixed line-scatter chart not corr 0
chart legend changing when I use Select data 1
Gantt chart duration not showing 0

Top