To create a Histogram Chart in Excel, you first need to have a dataset ready. Once your data is prepared, you can use the built-in Histogram tool to generate the chart.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

Excel automatically distributes these points along a uniform X axis. To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data.