Bar chart with 'target' lines but target varies per column

Hi,

I know how to change a data series so it can be a line graph. This is great if the target is a constant. I have a graph that has 4 columns of data (each with the same 3 series of bars). For example;

The 3 series are - Target, Actual, Planned
The 4 columns are - Quarter 1, Quarter 2, Quarter 3 and Quarter 4

The target for Q1 might be 50, Q2 100, Q3 150 and Q4 200. I want a line to only go through the Actual and Planned columns for that Quarter (i.e. not a line that goes up and down across the graph). As it is, I could draw a line however the target figure can (and knowing my luck, probably will) change from time to time.

Anyone with any ideas would be greatly appreciated.


Thanks,

Ineedcoffee