Hi,
If I understood correctly, you need to use a stacked bar chart.
First you add another column for your source data, then change the source data to include this new column and change the chart type to stacked bar and then finally you format some of the columns in the graph (by choosing the data point and deformat it). I'm attaching a file showing the steps.
BR,
|