Microsoft Office 2016: The Complete Guide (2015)


Visual aids are very important and effective when analyzing data and also helps in making your storytelling a compelling experience. Six new charts have been added to in Excel 2016. The same formatting options are made available to help in the creation of some of the most commonly used data visualization of hierarchical or financial information or to reveal statistical properties in your data.

To do this, simply follow the subsequent steps:

On the Insert Tab Click Insert Hierarchy Chart. The Sunburst or Treemap chart can be used.

For Histogram, Box and Whisker or Pareto charts, click Insert Stock Chart or Waterfall, or click Insert Statistical Chart.

Or, to see all the new charts click Recommended Charts and click All Charts.