A closer look at chart options

 In PowerPoint tips

f94aad3a-a464-4af9-9bf0-b4cd4a7248c6

As promised, today we are taking a closer look at the new chart types available with Office 2016 (these are available across Excel, Word and our hero… PowerPoint).  No doubt these new charts will help with visualisations that are critical to data analysis and compelling storytelling.

 

New charts available are:

6bddd054-159b-4f5f-baa3-851b89ec95c7

 

 

 

 

Treemap
Treemapping is a method of displaying hierarchical data by using nested rectangles.  Treemaps display hierarchical data with each branch of the tree being given a rectangle, and each sub-brunch is shown as a smaller rectangle.

6765e93e-fc85-4fed-89ef-89ca54524bbb* For full instructions on how to use Treemaps please click here.

Suburst
The sunburst chart will literally save hours of Illustrator work!  This chart shows the full hierarchy of different groups therefore providing deeper analysis.  At a glance you can see the largest segments within a hierarchy of multiple levels.

74ef5016-2e4f-4890-9e26-010173e23f5e* For full instructions on how to use Treemaps please click here.

Histogram
A histogram is a column chart that shows frequency data, that is, it is a graphical representation of the distribution of numerical data, and whilst it may look like a bar chart, a histogram is used for continuous data where the bins represent ranges of data and the areas of the rectangle are meaningful.  To create a histogram you need two lots of data, the data you’d like to analyse as well as the bin numbers that represent intervals by which you want to measure the frequency.

b277ce42-2486-45e8-ba46-1ee06b7b6b06* For full instructions on how to use Treemaps please click here.

Box & Whisker
A box and whisker chart shows groups of numerical data through their quartiles thereby providing a simple snapshot of the data’s characteristics.  The boxes may have lines extending vertically which are called ‘whiskers’, these indicate variability outside the upper and lower quartiles, and points outside those lines are considered outliers.

2581da8d-51c9-403a-827d-8069139acee7* For full instructions on how to use Treemaps please click here.

Waterfall
A waterfall chart helps to understand the cumulative effect of sequentially introduced positive and negative values.  It’s also known as a flying bricks chart or Mario chart, and often in finance it is referred to as a bridge.
Waterfall charts show a running total as values are added or subtracted, columns are colour coded to show positive and negative numbers.

21586811-7410-453d-97a1-df12c8f80c94* For full instructions on how to use Treemaps please click here.
**Chart images: www.office.com Office Blogs

Recent Posts