Skip main navigation

New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only. T&Cs apply

Find out more

Thermometer style custom visual

It is important that you are able to recreate this custom visual. Using the calculations you prepared in the previous step, take some time now to recreate this custom visual. …

Finishing tips 1

In the completed workbook you will find a copy of the Introduction sheet shown in this video. Hopefully from the article earlier, you are also familiar with the ability to …

Setting up the data validation

Finish setting up the charts as demonstrated in this video. First, change the settings so you can keep the formatting. Then set up the data validation as shown in this …

Creating and formatting the overlay

Using the formatted chart from the previous step, now take some time to create and format the overlay chart as shown in this video. Comment below: What are your main …

OFFSET, COUNT, CHOOSE & INDIRECT

In this article, we are going to quickly revise some of the Excel functions we have used and will use to create interactive and dynamic charts. Charting in Excel is …

Inputs and Calculation sheets

It is good practice to keep inputs, or original data on one sheet, with calculations and helper columns on different sheets. It would be common to see calculation sheets for …

Using Excel: Understanding Named Ranges

Named ranges in Excel are labels that you can assign to individual cells or cell ranges. This allows you to use range names anywhere you would use a cell or …