Chart Legends

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.

image alt text

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.

image alt text

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.

image alt text

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.

image alt text