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.

This chart lets you determine the minimum sales price at which you recoup your expenses for goods or services. Microsoft even provides a template for a simple Excel break-even chart.

How to Do a Two-Sided Graph in Excel. Microsoft Excel can present two series of data points together on the horizontal axis, but if the number scale for each series dramatically differs, the data ...

Create the chart/graph Once the data is entered, Excel does all the work—all you have to do is choose the chart you like the best.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.