ExcelBanter - Is there a posibbility to change/modify the Legends

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Is there a posibbility to change/modify the Legends (https://www.excelbanter.com/charts-charting-excel/42025-there-posibbility-change-modify-legends.html)

Is there a posibbility to change/modify the Legends

Could we customise the Chart legends without changing the Data Series ?

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

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