Complex Chart Help

[bkarl]

I want a simple chart to reflect the 'yes' or 'no' status for the following data - maybe a stacked bar or something - Quarters on the 'Y' axiS - Teams on the 'X' axis - 2 data points for each team/each quarter - I'm befuddled - help!

Team Quarter Test 1 Test 2
A Q1 Y N
Q2 Y Y
Q3 N Y
Q4 Y Y
B Q1 N Y
Q2 N N
Q3 Y Y
Q4 Y N
C Q1 Y N
Q2 N Y
Q3 Y Y
Q4 Y N
D Q1 N Y
Q2 Y Y
Q3 N Y
Q4 N N

 

[BAlGaInTl]

I'm a bit confused... a chart of what exactly? Charts plot numbers... you don't have any?

You say you want to plot 2 points, but what are the two points?
Is this the exact data you want to plot?
Is the data static or dynamic?

 

[bkarl]

Sorry - my data table didn't copy as expected - essentially I have 4 Teams with 2 tests each quarter (4 qarters) - each test is a yes or no (no actual numbers) and I wanted a 'chart' to graphically show the results (yes or no) of the 2 tests (a and b) for all 4 teams and all 4 quarters. Does that make sense?