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. …
Course: Design and Create Custom Dashboards in Excel
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 …
Applying dynamic formatting with data validation
Using the chart you prepared in the previous step, take some time now to add the dynamic formatting and the data validation. Make sure you can carry out the steps …
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 …
Waterfall part 2 – Creating our custom waterfall
Before you move on to the next video, make sure you are able to create a waterfall chart like me in this video. You can choose alternative formatting options if …
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 …
