Could we customise the Chart legends without changing the Data Series ?
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks