Can I run a histogram with non-numeric data in Excel?

J

Jerry W. Lewis

Not directly, but you could easily cobble something together. The
histogram created by the Analysis ToolPak is a custom bar chart based on
a table. You could easily modify that table after creation to use your
desired labels and count text frequencies by using COUNTIF().

Jerry
 
Top