i want to create a chart like this:
I think i could create this with a stacked bar chart.
But i dont know how to apply different colors according to being above/below plan value.
Does someone has already implemented something like that?
See attached sample qvw
Maybe like attached?
Two expressions in a stacked bar chart:
Hey thanks guys! That really helps me.
But how can i change the expression to geht it in another color if its below plan?
Could you post your sample qvw ?
Open the expression attributes of the first expression by clicking on the small plus sign next to the expression label on upper left corner of expression tab.
Then edit the background color attribute expression:
Three expressions in a stacked bar chart:
thats the right answer!
For Line and Mutlicolored Stacks .
I hope this Helps,
Got another requirement.
So far it looks like:
If I select more than one Year it looks like:
How can i get this to show grouped? I guess thats not possible?
At the moment ive got one expression for each year.
Not sure if I understand what you want to group here. Sample lines of data or a small sample QVW always help to understand where you are coming from.
Potentially, you can add more expressions to stack upon your bars.
Forget my last posting. Im ok with that now
Retrieving data ...