How do I create a Stacked Bar Chart where the Data shows against a target

Hi,

I am trying to create a stacked bar chart where the 2 sets of data should not add up but show the actual levels.

For example column 1 has figures of actual 453 but target was 914. When I create a stacked bar chart, the two figures are adding together and the bar is showing at 1,367 rather than sitting at 914 as this was the target.

I have attached the picutre of how my chart currently looks, but I would like the orange section to be sitting at 914 and not the combined total.

bar chart.JPG

many thanks for any advice on how I can achieve this.

thanks,