Hey,
When creating a histogram on Excel 2016 (Windows), when I got to format the horizontal axis, and go to change the bin width and number of bins, once I modify the number of bins to lets say 10, and then go to change the bin width, the number of bins automatically changes back to 1. This is the same with bin width, if I change the width to 2000, and then go to change the number of bins, the bin width automatically changes to 0. Why is this happening?

Thanks