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

  1. Hierarchy Chart/Tree Map
  2. Sunburst
  3. Water fall or Stock Chart
  4. Transform Cold data into a cool picture
  5. Instant Histogram
  6. Pareto Chart
  7. 3D map
  8. 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.

  1. 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

Hier

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 ChartSunburst

3. Water fall or Stock Chart

It is recommended to sort the data by any order to have the better insights.Screenshot 2016-01-02 12.13.11.png

4. Transform Cold data into a cool picture

This one is based on the Add-ins.

Screenshot 2016-01-02 13.10.54

Select your data to visualizeScreenshot 2016-01-02 12.21.56Screenshot 2016-01-02 12.22.02

Select ‘Settings’ to change the design of the chartsScreenshot 2016-01-02 12.24.11

5. Instant Histogram:

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

Screenshot 2016-01-02 13.38.51.png

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.

Screenshot 2016-01-02 13.50.36.png

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.

Screenshot 2016-01-02 13.55.08

It will open another sheet like below Screenshot 2016-01-02 14.00.36.png

then we can change the theme and other options like ‘2D Map’. “Play Tour” option will show an awesome chart with lively visual.

Screenshot 2016-01-02 14.02.13Screenshot 2016-01-02 14.03.48

8. One click Forecast

It has become more easy for the Data analysts who do forecast.

Select the data that you want to forecast and Go to ‘Data’ tab > Click on “Forecast Sheet”

Screenshot 2016-01-02 14.11.35

Adjust the “Seasonality” appropriatelyScreenshot 2016-01-02 14.17.37

Screenshot 2016-01-02 14.18.19

and your forecast is ready.

Hope you like these features and much more to come from Microsoft. Try these things and enjoy !

Advertisements

Famous quotes about Statistics !

Here are few famous quotes about Statistics !

  • A big computer, a complex algorithm and a long time does not equal science. –Robert Gentleman
  • Absence of evidence is not evidence of absence. –Carl Sagan
  • All generalizations are false, including this one. – Mark Twain
  • All models are wrong, but some are useful. –(George E. P. Box)
  • An approximate answer to the right problem is worth a good deal more than an exact answer to an approximate problem.” — John Tukey
  • Anyone who considers arithmetical methods of producing random digits is, of course, in a state of sin. – Von Neumann
  • Figures don’t lie, but liars do figure –Mark Twain
  • He uses statistics like a drunken man uses a lamp post, more for support than illumination. — Andrew Lang
  • I think it is much more interesting to live with uncertainty than to live with answers that might be wrong. –Richard Feynman
  • If you torture the data enough, nature will always confess. – Ronald Coase
  • If your experiment needs statistics, you ought to have done a better experiment. – Ernest Rutherford
  • In God we trust. All others must bring data. – Edwards Deming
  • It ain’t what you don’t know that gets you into trouble. It’s what you know for sure that just ain’t so. –Mark Twain
  • Say you were standing with one foot in the oven and one foot in an ice bucket. According to the percentage people, you should be perfectly comfortable. – Bobby Bragan, 1963
  • Statistical thinking will one day be as necessary a qualification for efficient citizenship as the ability to read and write.- G. Wells
  • Statisticians, like artists, have the bad habit of falling in love with their models. — George Box
  • Statistics – A subject which most statisticians find difficult but in which nearly all physicians are expert.
  • “Statistics are like bikinis. What they reveal is suggestive, but what they conceal is vital. –Aaron Levenstein
  • Strange events permit themselves the luxury of occurring. – Charlie Chan
  • The best thing about being a statistician is that you get to play in everyone’s backyard. –John Tukey
  • The combination of some data and an aching desire for an answer does not ensure that a reasonable answer can be extracted from a given body of data –Tukey
  • The death of one man is a tragedy. The death of millions is a statistic – Joseph Stalin
  • The greatest value of a picture is when it forces us to notice what we never expected to see. –John Tukey
  • The statistician cannot evade the responsibility for understanding the process he applies or recommends. –Sir Ronald A. Fisher
  • There are no routine statistical questions, only questionable statistical routines. – R. Cox
  • To call in the statistician after the experiment is done may be no more than asking him to perform a post-mortem examination: he may be able to say what the experiment died of. –A Fisher (1938)
  • We are drowning in information and starving for knowledge. –Rutherford D. Roger

You can add the famous quotes that you like in the comments. 🙂