Positioning the chart legend in Excel

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.

How can I reposition the chart legend?

Positioning the chart legend in Excel

Most default Excel chart types include a legend and most position that legend at the right hand side of the chart. If that suits you, then fine but if you want to either remove it or reposition it, then you can do so easily.

Select the chart and select Chart Options from the Chart menu. Click the Legend tab at the top.

From this screen you can remove the legend by clearing the Show Legend check box or reposition the legend by choosing any of the Placement options.



Nobody has commented on this tip yet. Be the first.


URL: (optional)


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!

Guru Spotlight
Christina Chan