Forum Discussion
Histogram Excel 2016 Help
I am trying to create a histogram with excel 2016, but each time I try it says I have non-numerical data in my bin range. My bin range consists of numbers like "8.5-9.5". Can I not use hyphens? I've seen it done before.
1 Reply
If a hyphen is added to the cell, the contents become an alphanumeric and Excel evaluates it as text. Hyphens can be added through custom cell formatting.
