Currently I have a bar chart that looks like this:
The red column is a subset of the green column (meaning that the green column is red column + some other data), so I want excel to combine them into one stacked bar with 4/5ths of the column colored red and the rest green, whilst leaving the other bars (blue, purple) as they are. How do I do this?
