A Chart Showing Three Dimensions of Data

This is a nice and smart chart that you can adapt to many situations when you need to display three dimensions of data. This will help you make your presentations look professional and your reports – impress your clients, managers, and colleagues.

In this example, the chart shows:

1. Change from 2015 to 2018
2. In Revenues and EBITDA
3. For three products

Despite the apparent complexity, the chart is very intuitive and is very quickly understood by the users. These measurements can be replaced with any others, for example:

– split by regions (countries), by departments within your company
– change from budget to actual,
– variance in different P&L (incomes, costs) or balance sheet amounts (inventory, fixed assets, accounts payable), or in physical measurements (number of units sold, number of customers or employees).

The heading and the commentary block on the chart can obviously be changed as well. You can also adjust the format of the chart (colors, fonts, etc.) as you like.

All components of the chart (arrows, columns, shaded areas) are native chart elements and are updated automatically as you change the source data, without any manual intervention.

The attached file contains the chart itself and very detailed step-by-step explanations of how such a chart can be set up from scratch. These instructions might serve as an Excel refresher and as a guide to developing other professionally designed charts.

File type: .xlsx

You must log in to submit a review.