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

Welcome to the forum!

1. Use Combo Chart
2. Use secondary axis for target series
3. Set both axis minimum and maximum bounds to the same scale

Hi, Thank you for the welcome.

I'm not sure if this is what I'm looking for - I've had a look at Combo charts and that whats to use the secondary axis as a line.

The chart I need to do must be a stacked one and show the levels. In my example the Homes Delivered total for Castle Point is 453 but the Target delivery was 914. I need my result to be that part of the bar is coloured dark blue for the 453 but the remainder of the bar up to 914 is orange. If you see in the example the bar it going over the 1000 line so it would appear to be adding these two results together. How do I get it to show at the correct level and not add them together?

Thanks,

Change the chart type to Clustered Columns.

Attach a sample workbook and I will show you.

Here is my sample workbook for you.

this is perfect, and makes sense now. I'm going to use your Method 2 as that is exactly what I need. Really appreicate all the help

hello how are you guys,i need help with microsoft office

the issue is i cant open it ,it crashes every time i try to pen it.