one way to determine the number of classes making histogram.
k = 1 + log2 n
where, k is the number of class
n is the number of samples
when using excel
=1+(log(n,2))
substitute n with the number of samples
Sturges, H. A. (1926). "The choice of a class interval".J. American Statistical Association: 65–66