Reputation: 2455
I have made the following chart:
When a user makes a selection, is it possible to display the resulting bars in different colors than the ones displayed on the photo? For example, now the bars are displayed in grey, dark blue, and light blue colors. When a user selects Q1, the 3 bars should be displayed in following collors: Red, Yellow, Green etc.
Upvotes: 0
Views: 2039
Reputation: 932
There are two ways of doing this:
from the "Expressions" Tab, if you click the "+" left to the expression, you will see a "background Color" - there you can also enter any calc. i.e :
if(Quarter='Q1', rgb(100,100,100),rgb(200,200,200))...
Upvotes: 1