On the Data worksheet, select Data Analysis in the Analysis group of the Data tab of the Ribbon. Select Histogram and click OK. Select the Price column as the Input Range and the Binsize column (starting on cell K1) as the Bin Range. Check the ‘Labels’ box. Choose cell M1 on the Data worksheet as the output range. Check the ‘Chart Output’ box. Do not check any additional boxes in the Descriptive Statistics menu.
