Chart Help::Stacked Column

[Saladsamurai]

Does anyone know how to do the following?

I have the following percentages



So there are 4 sub-categories (percentages) EACH of which fall into 2 main categories.

Correct
Both Cold = 50%
Both Hot = 40%

Incorrect
Hot = 5%
Cold = 6%


Now I have produced the following stacked column graph to show which
of the 4 subcategories fall into each of the 2 main categories




The problem is that I want to assign a color and series label to EACH of the 4 subcategories.

So under "Correct" from 0 - 50% will be one color and from 50 - 90 % will be another.

Then under "Incorrect" 0 - 5% will be yet another color and 5- 10% another.


I have tried so many different combos of source data that I can't even remember which I have already tried.

Any ides?

Thanks!

[Saladsamurai]

Anyone have any suggestions on this one? I tried putting the 50% and 60% ("Correct") in one column and 5% and 6% ("Incorrect") in another, but I still can't get it right?

I can't figure out what order to select the data so that it will format the way I want it.

[Bob Phillips]

You can select an individual data point and set its fill colour independently.

[Saladsamurai]

You can select an individual data point and set its fill colour independently.

I don't know... with the above plot, since both red potions are from the same series, when I right-click one of them and change the color, they BOTH change.

Still trying though.

Thanks!

[Andy Pope]

Lay your data out like this. In 3 columns over 5 rows.

<empty> Correct Incorrect
Both Cold 50% <empty>
Both Hot 40% <empty>
Hot <empty> 5%
Cold <empty> 6%

Create a stacked column plotted by rows.