Hello,
I have just watched the Interactive Excel Dashboards & One click update video on YouTube and have created my very 1st dashboard and pivot charts.
I have created 6 different charts with 5 of them showing different date that is grouped by contractors 5 in total. Each contactor is a specific colour. I've used these colours for my manual legend.
There are 2 issues I am having.
- when I select a specific contactor on my slider it is changing the colour on my charts ie Civils is Red but when I just select Civils alone it is showing as blue.
- One of my sliders is week number when I click on a week it is removing that week from my charts instead of just showing the data for that week.
Please can anyone advice on what I've done wrong and how I can rectify these issues.
Thank you in advance
Hi Katie,
It's an old issue, see more details here:
Rather that letting Excel set the colors automatically, choose the colors yourself as 'Solid Fill' when formatting a data series. I've done that in one your the charts (Hours by Reason) and the Contractor bars keep their designated colors when using the slicers.
Obviously, you'll have to do this for each chart in your dashboard.
See attached.
Thank you so much for taking the time to help.
I will look at link that Catalin sent and the attachment that Riny sent.
Hello,
I have now update all the charts with the solid fill. I've saved the file and it works fine, however when I closed my file and reopen it all formatting is lost. Could I be doing something wrong?
I have attached a screenshot highlighting what sections I change in Format Data Point.