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!
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.
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
A common requirement from Excel users is to merge multiple csv files into a single file for use in Excel. In this post we show a very effective way that makes use of the old DOS (you may not even … Continue reading
Excel users typically like to colour cells to highlight certain items. The problem is once you have all the cells highlighted, you will inevitably need to count or add them. There is currently no SUMIF, COUNTIF, AVERAGEIF that works on … Continue reading
Just a quick note to say your blog is brilliant. Full of useful bits of info. After your courses, I am by far the best modeller in our office, and we regularly get comments from our business partners on the quality of our models. Thanks for all the help,– Mike