| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Capture the legend title. Help
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Chart Title? | Charts and Charting in Excel | |||
| legend | Charts and Charting in Excel | |||
| Changing Graph Title W/ Pivot | Excel Discussion (Misc queries) | |||
| how to cell reference a Chart title | Charts and Charting in Excel | |||
| The x-axis title is truncated in EXCEL charts 2003. | Charts and Charting in Excel | |||
Linear Mode
