Most valuable professional
  • Excel Book Excerpt

Excel Legend At the Top

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

Legend At the Top

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.


Figure 1011 Move the legend to the top.

When you have a 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.


Figure 1012 Delete the legend when you have only one series.


<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: