Forum Discussion
Whibley92
Helper II
Helper IIChange colour within Clustered Column Chart based on Slicer
How do I change the colours dependent on slicer selection. I have 3 categories in my slicer - I would like each one to be a different colour when selected, ie Completed = green, Incomplete = red, Pen...
saud968
Memorable Member
Memorable MemberNo problem, we all have been in your position. I will request you to create an Excel sheet with some data remove the sensitive info and share that file. As it is difficult to understand what is going wrong when you are trying.
Whibley92Helper II
Helper IIThank you. This is very basic data.
| Learner Name | Status | Overall Status |
| Name 1 | Active-In Progress | Incomplete |
| Name 2 | Completed | Completed |
| Name 3 | Active-Not Started | Incomplete |
| Name 4 | Completed | Completed |
| Name 5 | Active-In Progress | Incomplete |
| Name 6 | Completed | Completed |
| Name 7 | Completed | Completed |
| Name 8 | Completed | Completed |
| Name 9 | Pending | Pending |
I am not using a slicer though as it doesnt perform the same when we selected as a table. The table keeps the total, then breaks down depending on which Overall Status selected.
- saud968
download this file https://drive.google.com/file/d/123vIFR6hhwKut44QnQ_JzoyO4mnEqaU7/view?usp=drivesdk
and review it is working as expected.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!