Hi
This is my post on here..i would like to say Chandoo you are awesome..
I have a spreadsheet where i have added a slicer to it..I have created a Pivot chart also.
What i want to do is add RAG conditional formatting to my RAG chart to dhow Green when over 3, Amber when = 3 and ref under 3
Now i now how to do this as a regular chart but not on a pivot chart..i need this so it updates when i chsnge selection for the slicer..
I am also trying to spice up this dashboard to be able to summarize by daily, weekly, monthly and yearly so the managers can choose to annalyze however they want..
I also wang to add forcasting based on the data I have...
Can someone please help me making this dadhboard even better and more interactive
Many many thanks
This is my post on here..i would like to say Chandoo you are awesome..
I have a spreadsheet where i have added a slicer to it..I have created a Pivot chart also.
What i want to do is add RAG conditional formatting to my RAG chart to dhow Green when over 3, Amber when = 3 and ref under 3
Now i now how to do this as a regular chart but not on a pivot chart..i need this so it updates when i chsnge selection for the slicer..
I am also trying to spice up this dashboard to be able to summarize by daily, weekly, monthly and yearly so the managers can choose to annalyze however they want..
I also wang to add forcasting based on the data I have...
Can someone please help me making this dadhboard even better and more interactive
Many many thanks