Help with making a chart do what i want it to

Hi Everyone,

Im not sure if what i want is possible but i figured i would ask at least.

My file has a table of a series of tests as column headers and a series of products going down column A. The data in the table is a test result being either "OK" or "Not OK". It looks a bit like this:


___________Test 1________Test 2______etc..

Product1_____OK_________Not OK

Product2_____OK___________OK

etc..

What i would like is a chart showing clustered columns of sum of "OK" or "Not OK" for each test. Made a small sketch in attachement.

A bonus would be if i could choose on the fly which tests to include in the chart

Thanks for any help
//Daniel

Sorry for the rookie mistakes. Attached is a representative example of the table i would like help with getting a chart for. The picture attached in OP should be enough of an outline of what i want i think

Thanks for the help to better my post

//Daniel

Yes! Thank you!