Tiny charts

When you want to display data that contains multiple separated series in a chart, it can often look clumsy. It is possible to tolerate presentation of three or four series, but anything more than that is a nightmare for those who watch the reports and need to draw a certain conclusion. The solution is to display several smaller, separate charts instead of one. This type of data presentation is called small multiples, and here’s how to achieve it in Excel reports.

Bullet Chart

Bullet is a type of Column or Bar chart where we display series one above the other, and later in their display settings we determine the way the series overlap. This is a simple chart that is suitable for comparing one larger and one smaller size, e.g. Budget and Actual sales values. How to create this type of chart you will find out in the following “recipe”…