# Make charts with users data from a form **URL:** \ **Category:** Ask for Help\ **Created:** [November 27, 2020, 11:38pm UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042 "2020-11-27T23:38:06Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 27, 2020, 11:38pm UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/1 "2020-11-27T23:38:06Z")
Hi all! I’m trying to show a chart in the user profile that uses different cells on a row that was inputted with a form. I know that I need a column to do the chart or at least different rows of the user, but I can’t figure out how to do it. To illustrate I have user 1 that got the result of 10 for the profile 1, 5 for the profile 2 and 17 for the profile 3 (all calculated with the data from one row). And I would like to make a donut chart. Thank you for your help ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 27, 2020, 11:40pm UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/2 "2020-11-27T23:40:56Z")
Within the form submission make sure theres a special value marked as user 's email address. So with that you can always pull the data from the columns using the email. ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 27, 2020, 11:48pm UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/3 "2020-11-27T23:48:06Z")
Thanks! I did that but my problem is that the values that I need to transform in rows of a column are calculations, based in the data. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 27, 2020, 11:50pm UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/4 "2020-11-27T23:50:50Z")
send me either a link to it or some screenshots if you dont mind. ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 27, 2020, 11:54pm UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/5 "2020-11-27T23:54:35Z")
Here is the link for the google sheets, I think is easier [https://docs.google.com/spreadsheets/d/1jckzZwIPgIGrs888W6fEoA6qU\_21XgTSvZyP87BG\_\_I/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1jckzZwIPgIGrs888W6fEoA6qU_21XgTSvZyP87BG__I/edit?usp=sharing) I want to use the results of the columns DJ, DK, DL and DM of the profile sheet as itens of a list or a chart ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:00am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/7 "2020-11-28T00:00:26Z")
Ok I understand what your trying to do. Which type of chart are you using? ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 28, 2020, 12:02am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/8 "2020-11-28T00:02:16Z")
The donut or the stack. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:02am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/9 "2020-11-28T00:02:56Z")
Take a quick screenshot of the settings and paste it in here. Use shift+Windows key+S ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 28, 2020, 12:06am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/10 "2020-11-28T00:06:13Z")
![Captura de pantalla 2020-11-28 a las 1.04.45](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab48d4d3beb1bdf861d08b1cb61a125fb66f9db4.jpeg) here appears just one result, not the 4 that I need ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:06am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/11 "2020-11-28T00:06:58Z")
what are the filter settings, they should be set to user sign in ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 28, 2020, 12:08am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/12 "2020-11-28T00:08:29Z")
![Captura de pantalla 2020-11-28 a las 1.08.07](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51be4b618f45b4ffc083705d22c958764a653716.png) ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:08am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/13 "2020-11-28T00:08:58Z")
and u alrdy had it set to that? ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 28, 2020, 12:09am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/14 "2020-11-28T00:09:14Z")
yes ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:10am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/15 "2020-11-28T00:10:26Z")
can u move the chart on the google sheet to away from the cells in question. I cant see which value its giving you. And you are michelle._ **@** _…com and currently signed in as that user? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:14am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/16 "2020-11-28T00:14:10Z")
If thats the case its displaying the correct information. Aside from that data what are you wanting it to do? Are you wanting it to only fill the donut chart partiall based on another value? Are you wanting multiple values to be displayed? ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 28, 2020, 12:16am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/17 "2020-11-28T00:16:47Z")
yes, but I only can put one data in the chart, I want to create one like this ![Captura de pantalla 2020-11-28 a las 1.16.31](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b50c1de672247d3e765e350cd660dc96ca8cf95.jpeg) ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:17am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/18 "2020-11-28T00:17:43Z")
I see, that data is setup vertically not horizontally. Either that or its multiple users data together. To view different data from different columns you will need a different chart. ---
**Author:** ![Onsanity\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onsanity_solutions/32/17231_2.png) [@Onsanity\_Solutions](https://community.glideapps.com/u/Onsanity_Solutions)\ **Post date:** [November 28, 2020, 12:19am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/19 "2020-11-28T00:19:15Z")
exactly, but my data is horizontal because is in an user row. I don’t know how to make a user register data in vertically ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:20am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/20 "2020-11-28T00:20:11Z")
you can actually. Use the combo actions and do it outside of a form ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [November 28, 2020, 12:21am UTC](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042/21 "2020-11-28T00:21:39Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/6456ae1a9e6f3eaec76e1acc56e0c85c1bb64fdf.png) you change the action to create new action. And in that action you can determine which row or column they enter data. [Next page](https://community.glideapps.com/t/make-charts-with-users-data-from-a-form/19042.md?page=2)