When you select Recommended Charts from the Insert tab, Excel displays a visual list of the charts that would most successfully represent your current dataset.

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.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.