This is going to be a longer post. I’ve broken down the final creation into a number of pieces.

In this first part – you can see how I start the dashboard by applying background colour and borders, creating a dropdown list and starting my calculations. You can view the completed file here

Part One – the set-up

Part Two – Gender charts


Part Three – adding our final charts