Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a posibbility to change/modify the Legends
Could we customise the Chart legends without changing the Data Series ?
|
#2
|
|||
|
|||
Hi,
No, the legend and data series will display the same formatting. Depending on the chart type you could add extra data series with no actual data. Format the legend entries as required and then delete the legend entries of the actual data. Cheers Andy Ash wrote: Could we customise the Chart legends without changing the Data Series ? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Depends on what exactly you want to change. Can you explain what yoru trying
to do? "Andy Pope" wrote: Hi, No, the legend and data series will display the same formatting. Depending on the chart type you could add extra data series with no actual data. Format the legend entries as required and then delete the legend entries of the actual data. Cheers Andy Ash wrote: Could we customise the Chart legends without changing the Data Series ? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Legend Entries | Excel Discussion (Misc queries) | |||
Order of items in legend | Charts and Charting in Excel | |||
How to hide a dummy series in a chart legend? | New Users to Excel | |||
XY Scatter Legend when Edit Individual Markers | Charts and Charting in Excel | |||
Subscript in legend? | Charts and Charting in Excel |