I am trying to
create a bar chart where I have a set of testing areas broken down
into pass, fail , blocked so it would look something like .... Test
area 1 with a bar for pass, a bar for blocked and then a third bar
broken down for severity 1, 3 and 3 fails..

the columns in the sheet would be "test Area",
"Verdict"(pass/fail/blocked), "Severity"(1,2 or 3 if column 2 data is
Fail)

I tried a pivot table but can only get the bar chart to show
pass,fail, blocked for each test area..

any help would be appreciated