•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Totaling responses from a field?
Our take
If you're looking to visualize the responses from your checkout page, you've come to the right place. Start by focusing on the third column, which contains the answers to "How did you find us." To create a pie chart or graph, you'll first need to organize the data. While the pre-filled responses can be easily counted, custom answers will require a bit more effort to categorize.
This is a pretty beginner question I think but my brain is fried today.
I have a spreadsheet with 3 columns. The first two I don't need at all. The last one is the filled with answers to "How did you find us" on our checkout page. I want to make a graph or pie chart that totals all the answers and shows the most common responses by percentages or count.
The column's data has several pre-filled answers they can select, but they can also write their own so there's tons of custom responses. I don't have a way to reformat it so each response is in it's own column which I think is what I need to do to properly display it?
Any help would be great!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#financial modeling with spreadsheets#rows.com#big data management in spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#conversational data analysis#Excel compatibility#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#real-time data collaboration#automation in spreadsheet workflows#intelligent data visualization#no-code spreadsheet solutions#AI-powered spreadsheet#data visualization tools