100% bar graphs in Excel for multiple categories

[kwilson529]

I have been able to create a 100% bar graph in excel for one set of data (one test, %fail/%pass/%exceed) but have not been able to make one for several tests. I would like to have a two tiers: first by grade, then by test.
I am working with Excel 2007.
If you need more clarification, please let me know.

 

[SkipVought]

Hi,

[tt]
Grade Test fail pass exceed
1st a 0.3 0.5 0.2
1st b 0.2 0.4 0.4
1st c 0.1 0.7 0.2
2nd aa 0.3 0.5 0.2
2nd bb 0.2 0.4 0.4
2nd cc 0.1 0.7 0.2
[/tt]
Your Category will be the data in columns A & B.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}