Next Live Training Date:

8-10 Dec (JHB)

Not sure which of these videos to watch? Try out our 'Which Excel Formula to Use' App to get guidance. NOTE: All these free Excel video tutorials are streamed via YouTube. If your network does not allow YouTube videos, you can access the video via your smartphone or from a different network.

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.

Handy Tips & Tricks

Drop down list in Excel not showing

Drop down list in Excel not showing Recently a client was complaining that the drop down list in Excel was not showing on a file we sent them. After some investigation we discovered that they had simply not scrolled up … Continue reading

PowerPivot Sort Month Names

Sort Month Names in PowerPivot One of the new features is the sort by columns feature in PowerPivot. This allows you to sort one column (e.g. weekday names) by another column (e.g. weekday number). This can be useful, for example, … Continue reading

It was most interesting and filled with very useful and relevant tricks and tools that one can start to use immediately. The course was well constructed with a logical flow to be able to reference information easily in the take home materials, with exercises covering many different scenarios.

– Hyatt Hotels

Video Library & Tutorials //

View Entire Video Gallery ››

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

Excel Group Rows 2013

Excel Group Rows 2013

Some of our Featured Clients