What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to pull data, charts, graphs, ect from survey

    Asked by davewebb on October 23, 2014 at 08:34 AM

    I have made a survey. Other than a excel spreadsheet how do I get data? When I looked at jotform survey tools it said I could make charts and pie charts with the data, this it why I chose Jotform to do my survey. Now I cant find how to pull out the data in a chart form.

     

    Thanks

    Dave

    Page URL:
    http://www.jotformpro.com/form/41745359287971

    survey pull data JotForm excel survey tools
  • Profile Image

    Answered by davewebb on October 23, 2014 at 10:06 AM

    I guess i did not explain properly. I can make the charts but they dont show both answers, only one at a time. How can I get a chart to show both answers at one time?

     

    Thanks

    Dave 

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on October 23, 2014 at 12:08 PM

    I assume you are talking about these visual reports, right?

    Please check this guide:

    https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-your-Form-Submissions

    If you want to embed the chart into a form, you can just use the Text field (under Form Tools) and paste the iFrame code of the report.

     

  • Profile Image

    Answered by davewebb on October 23, 2014 at 12:13 PM

    HA!! Thats it. Thanks Jeanette for your help.

     

    Have a great day!

    Dave

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on October 23, 2014 at 01:14 PM

    Thanks and likewise.  Very glad to be able to assist you!

    Cheers!

  • Profile Image

    Answered by davewebb on October 23, 2014 at 02:19 PM

    I did as was said in the how to guide but I only see one answer.

    How can I see both answers in the same chart?

  • Profile Image

    Answered by davewebb on October 23, 2014 at 02:29 PM

    My filter only gives me date range.

    No question & answer filter.

    Strange.

     

    Dave

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on October 23, 2014 at 05:23 PM

    I just inspected this, seems like the problem is that you are using matrix for the responses, rather than checkboxes. Please change these so they can be included in the chart.

  • Profile Image

    Answered by davewebb on October 24, 2014 at 09:20 AM

    Can I change them now that the survey is over?

    The reason I use matrix is that is the choose under survey tools. There is no check box under survey tools.

     

    Thanks

    Dave

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on October 24, 2014 at 12:42 PM

    Hello Dave

    The problem is that if you delete the matrix, then the data will be also deleted. In light of that, the only way for you to reproduce a chart is by downloading submissions in a Excel file and use Excel graphic chart features.

    How to Export Form Data to Excel?

  • Profile Image

    Answered by davewebb on October 24, 2014 at 01:29 PM

    Jeanette,

    Yeah that is what I been doing. So next time I do a survey I should not use the survey tools but use checkboxes? LOL, who would have guessed!

     

    Thanks for your help Jeanette.

    Have a good weekend,

    Dave

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on October 24, 2014 at 03:42 PM

    You're welcome