I can create a basic stacked bar chart. 3 columns of data (x-axis labels, data1 count, data1-2 count) results in a bar chart with 5 bars with data1-2 displayed on top of data1
x-axis 20, 15, 10, 5, 0
data1 3, 1, 2, 1, 1
data1-2 0, 5, 2, 1, 3
I’m wanting to create another data series in this same chart and have the data displayed stacked and beside data1’s bars. so resulting in 10 bars where data1-2 is stacked on data1 and data2-2 is stacked on data2 where in each category there are the pairs data1 next to data2.
I tried highlighting all the data and charting but resulting in just 5 bars of stacking data1, data1-2, data2, and data2-2 on top of each other.
Can what I’m thinking be done with Calc?