Top 8 Viz features in Excel 2016 !

This is especially for the excel lovers! In this blog, we will see few of the new and exciting data visualization features of Excel 2016.

Here is the list of new features

Hierarchy Chart/Tree Map
Sunburst
Water fall or Stock Chart
Transform Cold data into a cool picture
Instant Histogram
Pareto Chart
3D map
One click forecast

These are the most wanted charts by the Dashboard creators. These are very simple and attractive. This set of features makes excel more competitive with other expensive visualization tools.

Hierarchy Chart/Tree Map:

Select the data that you want to use for creation of the chart then Go to ‘Insert’ tab > Charts > Insert Hierarchy Chart

Isn’t it cool? OK, we go to the next one.

2. Sunburst/Donut Chart:

It is another representation of a Pie chart. An alternate to boring the Pie chart. Go to ‘Insert’ > Charts > Insert Hierarchy Chart

3. Water fall or Stock Chart

It is recommended to sort the data by any order to have the better insights.

4. Transform Cold data into a cool picture

This one is based on the Add-ins.

Select your data to visualize

Select ‘Settings’ to change the design of the charts

5. Instant Histogram:

Create histograms quickly instead of going to “Analysis Tool Pack” in add-ins. Go to Insert > Charts > Histogram

6. Pareto Chart:

Earlier, we had to customize the data structure to create ‘Pareto chart’ but now it is just a click away to explain the 80/20 principle.

7. 3D map:

Power Map, the popular 3-D geospatial visualization add-in for Excel 2013, is now fully integrated into Excel. Weâ€™ve also this feature a more descriptive name, â€œ3D Maps”. You’ll find this functionality alongside other visualization features on the Insert tab.