Hello everyone,
I'm having trouble with a dashboard i'm creating. The background color is set to white for all cells in the sheet.
I create a simple pivot that shows the evolution by ctry let say and add a slicer so that the user can select the country/countries he wants to see. There is also a pivot chart linked to the pivot.
The trouble is when he selects i.e. 4 countries the table will show 4 columns. Afterwards if he selects only one, the columns where the pivot used to be lose format, while i want them to keep the white background format.
I've attached a pic of what i mean hope it clears things.
Been struggling with this for quite a while on different ocassions.
Thanks for your help! 2015-08-05_113841.jpg
Bookmarks