Combine stacked and unstacked columns in single chart


You can do this in single chart, but need to specially align data to create this chart.

For each year you need to create two rows, where in first row you will have total value under total column and in second row you will have splitted values under various columns. Now you can direct create the desired chart.

Refer below image for data structure to create this chart.

combined_chart