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.
You can also reverse the order of the items in your legend using the Reverse Order slider in the Chart Properties panel.
Legend Spacing Options
You can adjust the settings for the spacing in your legend using the Chart Properties panel. Add more Padding to increase the space between the legend and the chart itself.
You can use Symbol Width to adjust space available for the markers in the legend. Use the Force Symbol Width setting to force legend markers fill the available space. For example, squares will display as rectangles.
You can further customize your chart by setting the Item Distance larger or smaller between items in your legend.
Legend Label Formatting
If you want a legend label to break onto two lines, go to the Data table for the chart and place your cursor in the appropriate cell in the first column of the table where you want the title to break.
Use CTRL+Enter for Windows or CMD+Enter for MAC to move part of the text onto a second line in the cell. This will move the same text onto a second line in the legend label.
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.
Add a Border and Fill to a Legend
You can add a border or fill to your chart legend using the options in the chart's Edit toolbar.
- Click on the legend to select.
- Use the Line Color icon drop down to select a color for the border.
- Use the Background Color icon to select a background color.