Forum Discussion
Histograms
I am attempting to create a histogram in Excel but I have two problems:
1) How might I set the minimum value of the axis to be something other than zero?
2) How do I set the bins such that rather than including values greater than the minimum value but less than OR equal to the maximum value (which is the default), a bin includes values greater than OR equal to the minimum but simply less than the maximum value?
Edit:
Also, how can I change the color of the frequency bars?
I solved my first problem; however, I still do not know how to set what data goes into what bin (see original post for full details).
How did you solve the problem?
The histograms in Excel seem to produce extra bins over the max values. How can I remove them?
Thanks for your help
Ignore my questions, I just realized my mistake
