Bin width: Select this option to specify how big the range of each bin should be. Simply right-click the x-axis and select Format Axis from the menu that appears. As you can see here, Excel attempts to derive the best configuration of bins based on your data. This would output a histogram with a supplemental line showing the distribution of values.Įxcel outputs a histogram chart based on the values in your source dataset.
Note that you can also have Excel create a histogram with a cumulative percentage. Select your data, click the Statistical Charts icon found on the Insert tab and then select the Histogram chart from the drop-down menu that appears. For instance, the raw data table shown here contains unique sales reps and the number of units each has sold. Start with a dataset that contains values for a unique group you want to bucket and count. This new chart type lets you essentially point and click your way into a histogram chart, leaving all the mathematical heavy lifting to Excel. Statistical charts help calculate and visualize common statistical analyses without the need to engage in brain-busting calculations.
