Hi Sathish welcome on Mynda's Forum. Do you want to make a chart of the 8 groups? So 8 values. Or do you want to make a chart of the answers of all questions and then for each question how many yes, how many no and how many n/a? And if it is only for groups, what is the groupvalue with for instance 3 questions answered with yes and 3 with n/a? So maybe it is possible for you to upload a test sheet with groups, questions (fake or not) and how you validate the answers so that is more clear what you want to present in the chart.

Frans

Hello Frans,

Thanks for asking.... here I am attaching an excel sheet with data...;

The sheet contains data from several Labs/offices, each office/lab answers some ~50 Questions with "YES", "NO" , "NA".

(with some comments which we can ignore at this stage...).

Each set of rows in the sheet are differentiated with colour code as they are of different category of questions (Fire, General, Pressure, Exit, etc), 

I am trying to take data from here and make some useful chart that can show how each office/Lab is doing in terms of each category.

Any guidance would be greatly appreciated....

Thanks

Sathish