Excel automatically inserts the graph, but it has no labels. Review the new green "Chart Tools" tab and ribbon at the top of the screen. If you don't see them, click the chart to enable them.

There are other charts available in Excel other than the most common ones mentioned, such as the Treemap chart. A Treemap chart provides a hierarchical view of data and makes it easy to spot patterns.

What to do with Excel 2016’s new chart styles: Treemap, Sunburst, and Box & Whisker. ... Data Labels, Gridlines, and/or Legend. Then click the paintbrush to change the chart’s design.

Pie charts are used to show percentages of the whole, and Line charts excel with data trends. The remaining chart designs include Area, Stock, Surface, Combo, Pareto, Histogram, and Sunburst.

We are going to add the values 30, 40, and 60, which add to 140. See photo above Now, we are going to make the second table, in which we will add data for the value, pointer.