Excel 2019 comes with two new types of graphic object,; these are 3D models and icons. 3D models are vector models of objects that we can add from the location on the disk or the Internet, and serve to better illustrate the data in the table. For example, if table contains a work order 3D model may be the product design we make. Icons are 2D graphic objects (SVG) that we can use in a similar way.
Excel 2019 has got a new type of maps that we can use to illustrate the data from the spreadsheets we’ve made. Actually, this is just another chart that we can add from Insert ribbon or after launching the Recommended Charts option. It allows us to create filled maps, where each country from the given dataset is filled by a color according to given values.
The Funnel chart is not a great novelty. In one of the earlier posts there were words about how to graphically represent the sales funnel, and what’s new is that this chart, that previously existed only in Office365 and Office Online editions, became part of Excel 2019. The Funnel chart is most useful when we want to display values (quantities, amounts) in relation to a certain business phase, and how to do it will be shown in the following scenario.
Box & Whisker charts are used for a statistical analysis of the data set. They come along with Excel 2016, and serve to show the statistical distribution of data according to quartiles, emphasizing the mean, maximum and minimum values. In business, they can be used, for example, to analyze the turnover of an item byclass or sales group. Then we analyze the value distribution, based on which we can make conclusions about future values.
Sunburst is another new chart brought to us with Excel 2016. It is suitable for displaying sales values (traffic, earnings, merchandise, etc.) according to periods, arranged by hierarchies such as: years, quarters, months, days … It reminiscent of a Doughnut Chart, because the width of the ring shows the value that we want to present. It differs in showing several rings, each corresponding to one of the hierarchies.