Excel - New Chart types Tutorial

In this video, you will learn about new chart types in PowerPoint 2016. The video covers six new chart types that have been added, including histogram options, Pareto, box whisker, and waterfall charts.
These new chart types have the same rich formatting options that you are familiar with, making it easy to create data visualizations for financial and hierarchical information or to reveal statistical properties in your data.
This tutorial will help you enhance your data visualization skills and create impactful presentations.

1:52
4474 views

Available in Microsoft365

Objectifs :

This document aims to provide a comprehensive overview of the new chart types introduced in Excel 2016, emphasizing their applications in data visualization and analysis. It will guide users on how to effectively utilize these charts for financial, hierarchical, and statistical data representation.

Chapitres :

Introduction to Data Visualization in Excel 2016
Visualizations play a crucial role in effective data analysis and storytelling. Excel 2016 has introduced six new chart types that come with rich formatting options, enabling users to create commonly used data visualizations for financial, hierarchical, and statistical information.
Hierarchical Charts
To access hierarchical charts, navigate to the Insert tab and click on 'Insert Hierarchy Chart'. Two notable types of hierarchical charts are: - **Sunburst Chart**: This chart is ideal for displaying hierarchical data. Each level of the hierarchy is represented by a ring or circle, with the innermost circle representing the top of the hierarchy. - **Tree Map Chart**: This chart displays categories using color and proximity, making it effective for showing large amounts of data that may be challenging to visualize with other chart types.
Stock Charts
In the realm of stock charts, the waterfall chart is particularly useful. It illustrates a running total as values are added or subtracted, helping users understand how an initial value, such as net income, is influenced by a series of positive and negative values.
Histogram Charts
Excel 2016 has introduced two new histogram charts: - **Pareto Chart**: This chart highlights the most significant factors in a dataset and is recognized as one of the seven basic tools of quality control. - **Box and Whisker Chart**: Commonly used in statistical analysis, this chart indicates variability outside the upper and lower quartiles. Any data point outside the whiskers is considered an outlier.
Accessing New Charts
Users can explore the new chart types by clicking on 'Recommend Charts' or 'All Charts' to view all available options. This feature allows for easy navigation and selection of the new charts introduced in Excel 2016.

FAQ :

What are the new chart types available in Excel 2016?

Excel 2016 introduced several new chart types including hierarchical charts like sunburst and tree map charts, waterfall charts for financial data, Pareto charts for quality control, and box and whisker charts for statistical analysis.

How do I create a sunburst chart in Excel?

To create a sunburst chart in Excel, go to the Insert tab, click on 'Insert Hierarchy Chart', and select 'Sunburst'. This chart is ideal for displaying hierarchical data.

What is the purpose of a waterfall chart?

A waterfall chart is used to visualize the cumulative effect of sequentially introduced positive or negative values, helping to understand how an initial value is affected by various changes.

What is a Pareto chart and how is it used?

A Pareto chart is a bar graph that represents the most significant factors in a dataset, based on the principle that a small number of causes often lead to the majority of problems. It is commonly used in quality control.

What does a box and whisker chart show?

A box and whisker chart displays the distribution of data based on a five-number summary, highlighting the median, quartiles, and potential outliers in the dataset.

Quelques cas d'usages :

Financial Analysis with Waterfall Charts

Waterfall charts can be used by financial analysts to visualize how net income is affected by various factors such as expenses and revenues, providing a clear picture of financial performance over time.

Quality Control in Manufacturing

Manufacturers can utilize Pareto charts to identify the most common defects in their production process, allowing them to focus on the most impactful issues and improve overall quality.

Statistical Reporting

Statisticians can apply box and whisker charts to report on data variability and identify outliers in research data, aiding in the interpretation of statistical results.

Data Presentation for Business Insights

Business analysts can use tree map charts to present complex datasets visually, making it easier for stakeholders to understand category distributions and relationships at a glance.

Hierarchical Data Representation

Organizations can implement sunburst charts to represent their organizational structure or product categories, providing a clear visual hierarchy that enhances understanding of relationships within the data.

Glossaire :

Data Visualization

The graphical representation of information and data, allowing for easier understanding and analysis of complex data sets.

Excel 2016

A version of Microsoft Excel, a spreadsheet program used for data organization, analysis, and visualization, released in 2015.

Hierarchical Charts

Charts that display data in a hierarchy, showing relationships between different levels of data.

Sunburst Chart

A type of hierarchical chart that displays data in concentric circles, with each ring representing a level of the hierarchy.

Tree Map Chart

A chart that displays data as nested rectangles, where the size and color of each rectangle represent different categories and values.

Waterfall Chart

A chart that visually represents the cumulative effect of sequentially introduced positive or negative values, often used to show how an initial value is affected by a series of changes.

Histogram

A graphical representation of the distribution of numerical data, often used to show frequency distributions.

Pareto Chart

A type of chart that highlights the most important factors in a dataset, based on the Pareto principle which states that roughly 80% of effects come from 20% of causes.

Box and Whisker Chart

A statistical chart that displays the distribution of data based on a five-number summary: minimum, first quartile, median, third quartile, and maximum.

Outlier

A data point that differs significantly from other observations in a dataset, often indicating variability or error.

00:00:05

to effective data analysis,

00:00:07

as well as compelling storytelling.

00:00:10

In Excel 2016 six new charts have been added

00:00:13

with the same rich formatting options

00:00:15

that you are familiar with

00:00:17

to help you create some of the most commonly used

00:00:19

data visualizations of financial

00:00:21

or hierarchical information

00:00:23

or for revealing statistical properties in your data.

00:00:27

Here's a presentation about the main news charts.

00:00:30

Let's begin with hierarchical charts.

00:00:34

In the Insert tab click on Insert Hierarchy Chart

00:00:37

to use the tree map chart or the sunburst chart.

00:00:41

Sunburst chart is ideal for displaying hierarchal data.

00:00:45

Each level of the hierarchy is represented by one ring

00:00:48

or circle with the intermost circle

00:00:50

as the top of the hierarchy.

00:00:52

Tree map charts display categories by color

00:00:55

and proximity and can easily show lots of data

00:00:58

which would be difficult with other types.

00:01:00

In stock charts the waterfall charts

00:01:02

shows a running total as values are added or subtracted.

00:01:06

It's useful for understanding how an initial value,

00:01:09

for example, net income is affected

00:01:11

by a series of positive and negative values.

00:01:15

In histogram charts two charts have been added.

00:01:18

Pareto charts highlight the biggest factors in a dataset,

00:01:22

and are considered one the seven basic tools

00:01:24

of quality control.

00:01:26

Box and whisker charts are most commonly used

00:01:29

in statistical analysis.

00:01:31

It indicates variability outside the upper

00:01:34

and lower qualities.

00:01:35

At any point outside those lines

00:01:37

all whiskers is considered an outlier.

00:01:40

Then you'll find some new stock charts

00:01:42

in the waterfall or stock charts section.

00:01:46

You can also click on Recommend Charts,

00:01:48

All Charts, to display all new charts.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2494 Views

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivo...

ALL COURSES