Excel: Legend At the Top

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: Excel always adds a legend on the right side of the chart. Visualization gurus say the legend should be at the top or left of the chart. You don't even need a legend for a one-series chart.

Strategy: Use Layout, Legend, Show Legend at Top.

  1. Move the legend to the top.

    When you have an Excel 2010 chart with a single series, Excel adds the series name as both the title and the legend. This is definitely overkill. Click the Legend and then press the Delete key on your keyboard. This is fixed in Excel 2013 - a chart with a single series will not have a legend.

  2. Delete the legend when you have only one series.

For more resources for Microsoft Excel