Can a single data series in a bar be 'unstacked'?

I’m trying to make a graph which shows the stacked sum of all inputs against a projection, is there way I can separate the last data series (which would be the projection) from the rest of the stack to be shown next to the stacked bar in the same x slot?

Put last data serie in the same column.

See sample file.

You can manually change the colors of the point areas of the last data series. To do that Edit the chart (double click on it), click in a data point, click in the square of a data point, secondary click, and select Format Data Point….

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.

Nice! feels a bit hacky but does exactly what I wanted it to. Thank you!

You’re welcome!