How to create a Bar Chart with stacked series with 1 regular at the same time?

[anoble1]

I have a chart I would like to show 3 values. I would like to leave the Blue Line and combine a stacked on the Grey & Orange. The Orange is where we are now and the Grey is what the goal needs to be. I need that beside the Blue though. Only need to combine 2 of them (Orange & Grey) Can this be one?

2020-11-13 08_15_06-Window.png

[MrShorty]

If I understand, it sounds like you are describing a "clustered and stacked" column chart. Here's a tutorial for such a chart: https://peltiertech.com/clustered-st...mn-bar-charts/ Note that most of the work is arranging the data in the spreadsheet. After that, the chart is a regular stacked column chart.

[PietBom]

Is this coming near ?
see attachment