Hello everyone

I have a question

I have a survey I made in Excel.

I need to find the percentage of this survey and graph it.

However, there is a different situation. Some questions are "positive", some are "negative".

sample survey question “shoes satisfaction survey” (total number of participants 18)

Yes No

question 1 - does it smell? 10 - 8

question 2 - is it easy to clean? 15 - 3

Those who said yes to the first question said yes to a "negative" situation for this shoe.

however, those who answered yes to the second question said yes for a "positive" case.

In this way, there are 20 different questions.

Based on these data

% pleased

% not glad

I need to find a ratio.

(Considering the positive and negative question)

After doing this I need to show it in graph.

can you help me?

Sorry for my English (Google Translate)