Sunburst

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.

Speedometer

When analyzing key performance indicators (KPIs) for their display is often used a gauge that resembles a speedometer in a car. This is not a standard Excel chart. There are commercial add-ins used to create this type of chart that could be found on the Internet, but there is a technique to create it by combining and modifying the existing charts of Doughnut and Pie Chart.

What kind of charts exist?

It’s not too difficult to create a chart, but you need to choose the type that best reflects our data. Excel has a multitude of charts, and every one of them suits best certain types of data. In the text that follows you will meet most commonly used charts, with suggestions on how to choose the right one that will meet your needs.