Stack Graph in Excel

Hi all, I'd like some assistance with graphs in Excel. Will make this real easy

I have 2 columns. One it Target one is Actual

Say the Target is 50million and actual is 25million I want a graph that shows the 25m inside the 50m - so giving the effect of a half full glass - sort of like a progress. IF the actual was 40m - i'd expect the "glass" to appear fuller.

If the actual exceeded the target the actual would break above the "rim line" of the glass.

When I do it, it just stacks the actual on top of the target. Showing the 50m first, then the 25m on top

Please can someone advise as I guess this is real easy thing to do

Thanks Olly, thant works apart from when the actual exceeds the target - I can't see the target line on the graph

Its ok, I have it now using 2nd axis. Thanks for your help