I have a database of information in columns and rows, much like a music library. i want to generate a pie chart from the information of one column, to see usage balances between the amount of times a certain term is used.
i want a pie chart, but if select the column i want and hit pie chart, it doesn't work, because it needs numbers, i need excel to count the amount of same entries and work them into a percentage of total, and then pie-chart it out...
Any help will be greatly appreciated!
Bookmarks