Consider making a PivotTable with an associated PivotChart using the
data as the source. Add the item column as both the row field and the
data field. For the latter make sure Excel shows Count of {field}
rather than some other option such as Sum of {field}
You can then sort the table and chart by the occurrence frequency.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.