Plot graphs for Hotjar survey with 4 questions

Hello, I have exported survey data in an Excel format.

I have asked 4 questions and I'd like you to create tabs with visualisations / charts of the data.

I need this done in such a way that I can paste in updated data and the charts will update.

Hotjar will give me basic visualisations of the data, relating to each individual question. However, I want you to be able to also show me data related specific answers for some of the questions.

For example, Q1 asks the user if they thought their visit was successful: Yes / No
Q2 asks them what they were hoping to find on their visit.

So I'd like you to be able to show me: of the people who were successful, what did they come to see and of the people who weren't, what did they come to see?

The next question asks them what industry they are from. Therefore, I'd like to be able to plot a chart that shows me: of the people from industry X what did they come to the website to find from this list of options: Apples to Bananas.

Ignore my budget. Quote your own. Please mention a fruit I've mentioned when you apply so that I know you've read this job properly.

I have all the data and I have approximately 7 charts I'd like you to plot.

Thank you.