PDA

View Full Version : Chart Help::Stacked Column



Saladsamurai
10-07-2009, 10:28 AM
Does anyone know how to do the following?

I have the following percentages

http://i12.photobucket.com/albums/a220/saladsamurai/untitled-1.jpg

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


http://i12.photobucket.com/albums/a220/saladsamurai/untitled2.jpg

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
10-09-2009, 06:45 AM
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
10-09-2009, 07:07 AM
You can select an individual data point and set its fill colour independently.

Saladsamurai
10-09-2009, 07:19 AM
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
10-10-2009, 08:47 AM
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.