My stacked column Bar chart is not showing the right data!

Good morning!

Right, I'm trying to show a a very basic stacked columm chart showing Targeted Savings vs Actual Savings by Quaterly Year - All this data is bogus for now.

My actual savings seems to be working nicely - but the targeted savings chart is not showing the figures in my table.

For example, actual savings were say £150,000 but targeted savings were £300,000 - My graph is showing this as about £440,000 as the target - What the heck is going on there?

I would also like the Y axis to be fixed at 500K but when changing this via Format Axis - it just totally screws up my graph.

Please see Spreadsheet attached to thread.

Any ideas? & Many thanks for reading.

James

Ok, just noticed, the data is adding together for some reason - How do I make them seperate??

Hi Andy, thanks for this! Seems obvious when you know (terrible with graphs me)

Rep added (once I've spread some apparently) !!!!