Category: Charts

Sunburst charts

A sunburst chart, available from Excel 2016 onwards, is a great way of visualising hierarchical attributes.   A simple example could be a company’s global sales, using a geographical hierarchy from continent, to country, to city with this dataset:     Select your data, go to the Insert menu and select Charts – See All Read More …

Graph trendlines

To add a trendline to your Excel chart or graph, right-click on the data series and go to ‘Add Trendline’. You will be met with the following options:     Exponential These are curved trendlines useful when your chart is demonstrating growth at increasing rates. For example, the growth of computer processing power has continued at an exponential Read More …