# Turning CHOICE form Data into a Chart **URL:** \ **Category:** Ask for Help\ **Created:** [July 4, 2020, 5:29pm UTC](https://community.glideapps.com/t/turning-choice-form-data-into-a-chart/11967 "2020-07-04T17:29:31Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 4, 2020, 5:29pm UTC](https://community.glideapps.com/t/turning-choice-form-data-into-a-chart/11967/1 "2020-07-04T17:29:31Z")
With some help from you guys, I was able to make a user onboarding survey using the CHOICE form! Users take the survey to choose preferences in many different categories (coffee v tea v cocoa) etc. I have a google sheet tab with the options and another sheet that records the user’s choices. I tried to render a chart that shows ALL of the choices in a pie, but it is only showing the data from ONE of the many choice categories. I watched the charts tutorial and it talks about creating a multiple relation in a new tab but I have tried doing that and don’t understand how to match the multiple choices into the form for each user. It’s very hard to explain it all in a message so I’ve picked up from here in this quick video. [https://share.vidyard.com/watch/8ituuzU7CPdeJ6KB4thuig](https://share.vidyard.com/watch/8ituuzU7CPdeJ6KB4thuig)? As always, I’m sure I’m missing something simple and appreciate any help! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 4, 2020, 5:32pm UTC](https://community.glideapps.com/t/turning-choice-form-data-into-a-chart/11967/2 "2020-07-04T17:32:44Z")
What do you expect the final chart to look like? Is it multiple charts that would show aggregated data column by column? ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [July 4, 2020, 7:03pm UTC](https://community.glideapps.com/t/turning-choice-form-data-into-a-chart/11967/3 "2020-07-04T19:03:12Z")
Hi Deena! As Thinh stated, how you want your chart to appear will affect the solution. If you want all of your choices to be “grouped together” in Glide, you’ll need to rename them as an array (preference 1, preference 2, preference 3, etc.) ---
**Author:** ![Gregorio\_Martinez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregorio_martinez/32/7299_2.png) [@Gregorio\_Martinez](https://community.glideapps.com/u/Gregorio_Martinez)\ **Post date:** [July 4, 2020, 8:38pm UTC](https://community.glideapps.com/t/turning-choice-form-data-into-a-chart/11967/4 "2020-07-04T20:38:54Z")
I have similar questions. Thank you for the video. I need visuals and this has helped. I’m excited to see your successful working chart aggregation. ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 4, 2020, 8:58pm UTC](https://community.glideapps.com/t/turning-choice-form-data-into-a-chart/11967/5 "2020-07-04T20:58:11Z")
Hi all, I got pulled away by my 7 years old - he says I’m spending too much time Gliding :-). I am still working through this and will update with my progress or questions tomorrow. @ThinhDinh asked me a great question and forced me to think about data visualization. Thanks and have a great 4th! ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 4, 2020, 8:58pm UTC](https://community.glideapps.com/t/turning-choice-form-data-into-a-chart/11967/6 "2020-07-04T20:58:33Z")
Will post a video with my progress tomorrow!