Next Live Training Date:

NEW: Dashboards 8 Dec 2016

Not sure which Excel course you should do? Try out our free Which Excel Course Should you do" questionnaire. 20 questions and you will know exactly what course you should do!

Change Chart Legend

Change Chart Legend
Watch this video

How to customise the legend in an Excel chart

  • 01:11
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

Change Chart Legend

The Chart Legend, normally situated over here, makes it easier to understand what is happening in the chart, especially if there is more than one item.

You can customize it, click on it, right click and say Format Legend and you get these options. Now these ones, Fill, Border Colour, Style, Shadow are pretty standard. The unique item here is called Legend Options and you’ll see you can specify where the Legend should appear – so maybe you want it to appear at the top and you’ll see it has moved here. Bottom – it is now shown at the bottom. Left, Right, Top Right. You can also see you can choose whether the Legend is allowed to overlap the chart or not. If I tick it off, you’ll see now the Legend fills in there. Be aware as well that you are not constrained by only those options If you hover over it and get it to change to the little four arrows, click and you can drag it wherever you want to on your chart.

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

AuditExcel sponsors the Financial Modelling in Excel Meetup Group in South Africa

We recently held our first Meetup group for South Africa. If you don’t know what Meetup is, it is a site to arrange ‘meetups’ for like minded people. In this case it is for everyone who loves all things Excel and … Continue reading

The risks of Excel’s auto format feature

Everyone loves that way Excel can second guess what you mean when you type something into a cell and it (correctly) changes the format. Type 2 Sept and it will automatically format it as a date. But there are some … Continue reading

Adrian was really good. He explained everything really professionally- Bookkeeper.
It dealt with my daily challenges at work- IS Management Accountant.
There was nothing I did not like about the workshop. Adrian was fantastic- Accountant.

– Excel Testimonials

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients