Chart Drill
Exercise 5: Remove the legend and show data labels
Task
With only one series, the legend isn't needed. Remove it and show the values above the bars (data labels).
Moves 0 (target 2)
FileHome
| Branch | Sales |
| New York | 520 |
| Chicago | 380 |
| Houston | 260 |
| Seattle | 210 |
With only one series, the legend isn't needed. Remove it and show the values above the bars (data labels).
This drill is for computer screens. On a phone you can review the steps.
- Select the chart and click the "+" (Chart Elements) at the top right
- Clear Legend and check Data Labels
- Another way: Chart Design > Add Chart Element > Legend > None, and Data Labels > Outside End
- You can also click the legend and press Delete
Key takeaway
Values above the bars show the size without reading the axis.
See Excel Charts for details.