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.