Dear all,
i have one column which contains 70 unique and different answers for one question, I'm trying to put all the answers in a good graph and make it visible as possible, any suggestions which graph to use and how to do it?
thanks for your usual help
Maybe a Scatter Plot: https://support.microsoft.com/en-us/...ersion=Windows
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If all you have is 70 statements there is not really a 'good' way of showing that other than a list.
If you have 70 unique replies but with multiple occurrances then you could rank on frequency in a bar chart.
Can you group the unique statements in anyway to reduce to more meaningful list?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks