This is driving me NUTS!! I just want to plot a stacked bar next to a regular bar

[kidmullet11]

Working on a Mac so may be different to PC functionality - all I want to do is have two bars per year (2022-2025), one bar to be regular representing just one column in my data table (Linear TV), and one stacked bar next to the regular bar showing three other values together (CTV, Social Video and Other). That's it but for some bizarre reason Excel will not comply! Please help based on the data table and output thus far. (Have tried playing around with changing chart type for each value but no cigar!) thanks

 

[RoryA]

It's not actually as easy as you might expect. See Debra's tutorial here: How to Make Excel Clustered Stacked Column Chart - Data Fix