Como posso integrar um gráfico no excel às respostas do formulário?

Olá!

Tenho um gráfico no excel que gostaria de integrar com as respostas do formulário, de forma que as respostas do formulário atualizem uma tabela automaticamente, gerando o gráfico.

Isso é possível?

Hi Lucca,

Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

Now, let me help you with your question. Just to clarify, are you referring to adding the chart that you have mentioned to the form Tables page? If yes, this is not possible but if you would like to view your submission data via Chart in Tables, you can create a new tab using Reports. Here's how to do it:

• In Tables, click on Add Tab.
• Click on Reports and then click on Next.
• Select the correct form and then click on Next.
• Select your preferred Report Type and then click on Next.

Give it a try and let us know how it goes.

Hello!
It’s fine, we can try and find a solution in English.
I’ll explain what I’m trying to do and you can check if that’s possible, ok?
So, I’m Building an assessment using jotform. Based on the answers of the assessment on jotform, I will fill out an external spreadsheet, that’s gonna use the data to create a chart.
My question is: is it possible to do all the Steps above without using an external spreadsheet?
Ideally, jotform would collect the data on the assessment and create a specific chart. The informations on the chart would be, for example:
I have 10 questions, all answered with “yes” or no. If the first five are answered yes, the result of the assessment is gonna be “Level 1”. If all questions are answered with “yes”, “Level 2”. The chart would present this information.
I hope I made myself clear. Thanks for the support 😊
De: Jotform <noreply>
Enviada em: quinta-feira, 3 de agosto de 2023 11:57
Para: Lucca Gregório <lucca.gregorio>
Assunto: Re: Como posso integrar um gráfico no excel às respostas do formulário?
[Jotform]<https:>
[Autoresponder]
There’s a new response on your question:
Como posso integrar um gráfico no excel às respostas do formulário?
Hi Lucca,
Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.
Now, let me help you with your question. Just to clarify, are you referring to adding the chart that you have mentioned to the form Tables page? If yes, this is not possible but if you would like to view your submission data via Chart in Tables, you can create a new tab using Reports. Here's how to do it:
· In Tables, click on Add Tab.
· Click on Reports and then click on Next.
· Select the correct form and then click on Next.
· Select your preferred Report Type and then click on Next.
[https://www.jotform.com/uploads/forum/Christopher_T/1691074601_64cbc029df44d_chrome_AxgiIZBvrk.gif]
Give it a try and let us know how it goes.
[Autoresponder]
Answered by
Christopher_T
View this thread<https:>
[Jotform Team]
4 Embarcadero Center, Suite 780, San Francisco CA 94111
24/7 Support<https:>
Unsubscribe Thread<https:>
</https:></https:></https:></https:></lucca.gregorio></noreply>...

Hi Lucca,

Thanks for getting back to us. Unfortunately, it is not possible to create a Visual Report with conditional logic. The Visual Report is created using all the submission data of the form. We can only use conditional logic to show/hide form elements. For more information about conditional logic, check out this guide.

Let us know if there’s anything else we can help you with.