I created a histogram to track the count of items at various price points. (See image below.) I did this manually; I did not use the "Show Me" feature to create this. My bin size is 0.05 (i.e., 5 cents). The resulting histogram is great, shows me exactly what I need within the range of existing values, including cases where the count is 0.
The issue is that I would like to:
1. Force the MIN of the histogram to 0. (The first value currently is in the 1.00-1.05 range.)
2. Force the MAX of the histogram to 25. (The last value currently is in the 10.25-10.30 range.)
Is there a way to do this with bins and/or histograms that does not involve a large CASE statement? Thanks.
Found the solution (from the Main Menu):
Analysis -> Table Layout -> Show Empty Columns
With this turned on it gives me the full range of values in the bin, from 0 to the max.