Forum Discussion
Matt_Fischer-Daly
Sep 17, 2020Copper Contributor
Excel charts: how to move data labels to legend
How can data labels be moved to the legend in a chart in Excel?
HansVogelaar
Sep 17, 2020MVP
You can't do that, but you can show a data table below the chart instead of data labels:
- Click anywhere on the chart.
- On the Design tab of the ribbon (under Chart Tools), in the Chart Layouts group, click Add Chart Element > Data Table > With Legend Keys (or No Legend Keys if you prefer)
Matt_Fischer-Daly
Sep 18, 2020Copper Contributor
Thanks HansVogelaar