To the right of the Recommended Charts button on the ribbon, you'll see this:
Excel 2016: Creating Charts and Diagrams In Excel 2016, charts and diagrams can show trends, averages, high and low points, and more. Not only do they make your worksheets more visually appealing, they also serve a definite function.
You can use these buttons and their dropdown menus to create these types and styles of charts. We're going to go from left to right, starting at the top left, and cover all the buttons above.
Insert Column or Bar Chart. This is the first button, located in the top left corner. With this, you can preview data as a 2-D or 3-D vertical column chart or as a 2-D or 3-D horizontal bar chart.
Insert Hierarchy Chart. Use this chart to compare a part to a whole or to show the hierarchy of several columns or categories.
Insert Waterfall or Stock Chart. The waterfall chart is used to show how a starting value is affected by a series of positive and negative values, while the stock chart is used to show the trend of a stock's value over time.
Insert Line or Area Chart. This lets you preview data as a 2-D or 3-D line or area chart.
Insert Statistic Chart. Use these charts to show a statistical analysis of your data. Chart types include Histogram, Pareto, and Box and Whisker charts.
Insert Combo Chart. These charts are best when you have mixed data or want to emphasize different types of information. You can preview your data as a 2-D combo clustered column and line chart – or clustered column and stacked area chart.
Insert Pie or Doughnut Chart. You can preview data as a 2-D or 3-D pie or 2-D doughnut chart.
Insert Scatter (X,Y) or Bubble Chart. Preview data as a 2-D scatter or bubble chart.