Chart Drill

Exercise 5: Remove the legend and show data labels

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.

  1. Select the chart and click the "+" (Chart Elements) at the top right
  2. Clear Legend and check Data Labels
  3. Another way: Chart Design > Add Chart Element > Legend > None, and Data Labels > Outside End
  4. 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.

← Back to all exercises