•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Totaling responses from a field?
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]
Want to read more?
Check out the full article on the original site
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