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.
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!
New Online Data Cleanup Course, Repair Corrupt Files, tables slowing Excel down, Excel and BI In this issue: Next Advanced Excel course dates 12-16 Oct, 9-13 Nov Beginner Excel Course Dates- Next 12 Feb 2016 Data Cleanup online Course In … Continue reading
Data table slowing down Excel Data tables are a great feature in Excel but it can be the cause of Excel slowing down during operations and resulting in the closing of a file taking lots of time. Data table slowing … Continue reading
...AuditExcel are professional, technically competent and provide solution suited to individual business needs. We are still using the reports and the budget tool they designed and have since been able to enhance the reports ourselves– Spreadsheet budget app- BDO Auditors