Target distribution line on bar chart

[Anonymous]

I have a bar chart that I use to show the distribution of monthly sales between new business and existing business. I would like to be able to project a line on top of the chart that shows where we would like the distribution to be. For instance, if June's sales were $400 to new business and $600 to existing business and we want salespeople to target a 50/50 distribution, the line chart would pass through the month at the $500 point.

Here's an Excel rendition of what I'd like the chart to look like:

Can a create a similar target distribution line in QlikView? I've attached a QVW containing the same sample data.

Thanks. -- Ben

[Anonymous · Accepted solution]

Ben, see attached

[Gysbert_Wassenaar]

See attached qvw

[Anonymous]

Perfect. Michael / Gysbert, thank you for getting back to me so quickly. -- Ben