Hi
I have been working on a dashboard for my team and am almost complete but am stuck on just a few things. I have searched forums and looked at videos but cannot figure it out.
I have attached the workbook which has 3 tabs:
1. Source Data
2. Pivot Tables
3. Dashboard
I am trying to figure out the following:
1. How do I set up a Conditional Formatted Progress Doughnut Chart. I have tried a few ways and it is a bit clunky. I would like the 7 charts' progress to match the value in the middle of the chart.
2. I have two campaign figures which I would like to update as I select the country. When I click on each week and a specific country, the weekly figures update but the campaign value remains static (for all, not just that country). This is for Web Leads and Inbound Calls on the right side of the dashboard. This is highlighted in bright green text.
3. I would like to show Week-on-Week change next to each figure. So when I click on a specific week it will show me the % change from the previous week. This is highlighted in yellow boxes.
4. In the top right of the dashboard it shows the name of 1 country, when everything is selected. What I want it to show is 'ALL' but am not sure how to do it. This is highlighted in bright blue in the top right.
I hope i have explained this clearly and someone is able to assist me with this.
Thanks a lot!
Bookmarks