Count "Yes"an "No" answers in a Survey with several questions.

I have Sharepoint Surveys which return information in the form presented as the first table in the reduced test case file.

I have created a second table to illustrate the possible answers.

I would like to create a table counting the "Sim" and "Não" (Yes and No) and Chart it using Pivot Tables, but I haven't found a way to count the text information to give me the desired table format.

I would appreciate help on this matter, thanks!

(I'm new to Pivot Tables)

reduced test case.xls:
reduced test case.xlsx

Thanks for the reply!

The thing is:

I need Pivot Charts, because they are created from PivotTables, because they can be named and added to a SharePoint page. I cannot do that with plain charts.
(It's even possible to display plain charts, but I cannot name them and pick a specific one from a Workbook to display on a SharePoint page).

That, I'd have to do that from a Pivot Table.

I am interested in generating basically 3 types of charts:

pie charts from numerical values about rural property land use;

Combo Charts using column + line counting the % of Yes compared to Total Answers. (count of surveys = 100%)
Several values (columns) would be grouped on each chart by topic.
THe line combo would be the average of all values on the several column, to get an average performance metric.

Radar Combo charts displaying the same information as the column + line combo above (because people want Radar Charts).

The Charts themselves are not the problem, they already exist as plain spreadsheets+charts.

The thing is the requirement to make them in Sharepoint Online, and to do that the data must come from a Pivot Table and the Charts must be Named Pivot Charts.

Maybe I must look at the problem from a different angle, or arrange my data differently.

The first table at the top left of the attached document represents the way the Survey is exported from Sharepoint to Excel via a Connection. I can't really change that apart from changing which columns are exported.

Any different way to tackle the problem? Would there be a way I can reorganize the data so that I can create a Pivot Table with the desired results?