Bar Chart Color -> above and below Value

[Anonymous]

Hi,

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?

Phil

[tresesco]

See attached sample qvw

[swuehl]

Maybe like attached?

Two expressions in a stacked bar chart:

=Rangemin(sum(Expression3), vThreshold)

=if(sum(Expression3)>vThreshold, sum(Expression3)-vThreshold)

[Anonymous]

Hey thanks guys! That really helps me.

But how can i change the expression to geht it in another color if its below plan?

[tresesco]

Could you post your sample qvw ?

[swuehl]

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:

=Black()

[jonathandienst · Accepted solution]

Three expressions in a stacked bar chart:

=Rangemin(sum(Expression3), vThreshold)

=if(sum(Expression3)>vThreshold, sum(Expression3)-vThreshold)

=if(sum(Expression3)<vThreshold, vThreshold-sum(Expression3))

[HirisH_V7]

Hi,

PFA,

For Line and Mutlicolored Stacks .

I hope this Helps,

Regards,

Hirish.

[Anonymous]

Hi Jonathan,

thats the right answer!

Thanks alot!

Phil

[Anonymous]

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.