Chart LegendsLast updated on 03/20/19
You can format legends on charts in a variety of ways to clarify the data presented.
Show Chart Legends
The chart Legend option is at the bottom of the Chart Properties panel. Use the slider to choose whether or not to show a legend.
If you are displaying a legend, you can choose the placement to have the legend at the Top, Bottom, Left, or Right of your chart.
Additional Chart Legend Options
You can also reverse the order of the items in your legend; adjust the padding and symbol width; and use Force Symbol Width to make bar, area and pie legend markers display as rectangles rather than squares. Finally, you can further customize your chart by setting the Item Distance between items in your legend.
Adding a border to columns or pie slices in a chart will also add a border to the series legend marker. This makes it easier to distinguish which legend marker is related to a series.
Hide a Series in a Chart Legend
To hide a chart series from the legend, select the series in the Series section in the Chart Properties panel. Then disable Show in Legend at the bottom of the Series section. The series will still appear in the chart, but not in the legend.