Planned vs Actual Stacked Graph

Hi,

I am looking to build a graph from the attached table where I can see the planned (EXT/INT) vs actual (EXT/INT) values side by side for each division (PSC/TSC/DSC/GTTSC/TOTAL) in a stacked bar.

EXP+INT PLAN in one stacked bar and then EXP+INT ACT adjacent to this for PSC and then this repeated for the other divisions.

I have attached the file and existing graph.

Thanks

I could be misunderstanding, but it sounds like you want a clustered and stacked column chart. Here's a tutorial for creating clustered and stacked column (and bar) charts. Note that most of the work is arranging the data in the spreadsheet, the chart itself is still a basic stacked column chart.
https://peltiertech.com/clustered-st...mn-bar-charts/