It can be done but there are several steps. It requires your data to be rearranged.
Do a web search for something like Excel mixed clustered stacked column chart. You will find several step-by-step guides, videos, tutorials on how to do it.
Here's a good one.
Stacked Cluster Chart