Gap Analysis with a Stacked Bar Chart

[#1]

Dear Community,

I have a problem in creating a Stacked Bar Chart.

The basics are clear to me, that means I know how to create a Stacked Bar Chart.

Unfortunately I'm not able to meet my requirement in total.

Short description of my Problem:

I have to build up a Chart that compares a actual value with a planned value.

For example, I need to visit 6 Clients per day and my actual is 4.

Now I want to show a chart that shows the actual part of the bar in green.

The part of the missing 2 visits must be displayed in Yellow.

So everybody can see the gap.

Furthermore there is another scenario that could happen.

A person might be able to visit 8/6 clients a day.

Now the chart should look as the following. The planned area (6) need to be displayed in green.

The part of the more visits need to be displayed in red.

I hope you understand my problem.

I'am looking forward to your comments.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. Is that what you're looking for?

[#3]

Gysbert that is exactly what I'm looking for!

Thank you very very much for the quick answer!

Perfect!

[#4]

Hi Gysbert, do you have any ideas how I can design the qvw that it looks like this example?

[hschultz]

Hi there.

Is this what you are looking for?

[#6]

Thank you very much. That is what I'm looking for.