Log In
Register
Home
Active Member
October 19, 2023
Offline
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Moderators
January 31, 2022
Offline
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.
Active Member
October 19, 2023
Offline
Thank you so much for taking the time to help.
I will look at link that Catalin sent and the attachment that Riny sent.
Active Member
October 19, 2023
Offline
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.
1 Guest(s)
