I'm trying to create a column chart in Numbers where each column is also stacked. For example, consider the following data.
Here we have numbers for the total sample and numbers for how that total is actually the average of two segments. I've already graphed a stacked column chart of the total sample, which looks something like this:
Now I'm trying to create a chart that shows the differences in the segments while also displaying the stacks for each individual segment. For the above data, it might look something like this:
I've successfully created the column charts in Numbers that show the total sample stacked or that show the segments, but unstacked. I'm trying to create one that shows the segments comparison with the stacked totals.
Is this possible in Numbers? Excel? Or should I just do it manually (which will really suck, because eventually I'm going to have dozens of these) in OmniGraffle?