ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I run a histogram with non-numeric data in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/53131-can-i-run-histogram-non-numeric-data-excel.html)

QATegan

Can I run a histogram with non-numeric data in Excel?
 
Example: E01a, E01b, E02a, E03a would be the bins.

Jerry W. Lewis

Can I run a histogram with non-numeric data in Excel?
 
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

QATegan wrote:

Example: E01a, E01b, E02a, E03a would be the bins.




All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com