Select the data that you want to forecast and Go to ‘Data’ tab > Click on “Forecast Sheet” It has become more easy for the Data analysts who do forecast. “Play Tour” option will show an awesome chart with lively visual. Then we can change the theme and other options like ‘2D Map’. You’ll find this functionality alongside other visualization features on the Insert tab. We’ve also this feature a more descriptive name, “3D Maps”. Power Map, the popular 3-D geospatial visualization add-in for Excel 2013, is now fully integrated into Excel. Go to Insert > Charts > HistogramĮarlier, 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. Select ‘Settings’ to change the design of the chartsĬreate histograms quickly instead of going to “Analysis Tool Pack” in add-ins. It is recommended to sort the data by any order to have the better insights.Ĥ. Transform Cold data into a cool picture An alternate to boring the Pie chart. Go to ‘Insert’ > Charts > Insert Hierarchy Chart It is another representation of a Pie chart. Isn’t it cool? OK, we go to the next one. Select the data that you want to use for creation of the chart then Go to ‘Insert’ tab > Charts > Insert Hierarchy Chart This set of features makes excel more competitive with other expensive visualization tools. These are the most wanted charts by the Dashboard creators.

Transform Cold data into a cool picture.

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.

Belajar dashboard excel