Skip main navigation

New offer! Get 30% off your first 2 months of Unlimited Monthly. Start your subscription for just £35.99 £24.99. New subscribers only T&Cs apply

Find out more

The different chart types

As we’ve seen, there are seven different chart types to choose from. But which one should you use? The answer depends entirely upon your data and the story you’re trying …

Change the chart styles

Once you’ve chosen the right chart type for your data, it’s time to apply some style. Chart style gallery On the Design tab of the ribbon, the chart styles gallery …

Why we want to connect pivot filters

After watching this video, you should understand some of the reasons you might consider connecting pivot tables, and some of the risks if you don’t connect them when needed.

Adding records

Before reading this article, continue working on the file from the previous activity or download this activity file and open it in preparation. Whilst refreshing the data cache from a …

Why connect data sources?

When your source data is a complete data set and contains all of the detail you need to summarise your data by the required collections – you won’t have to …

What is a data set?

After watching this video, you should be able to describe what a data set is, and explain how they can give insights into business performance. Share your thoughts In the …

What is a pivot table?

After watching this video, you should be able to describe what a pivot table is, what purposes they can be used for, and how they can help measure and summarise …

The three main filters to explore

After watching this video, you should understand the filtering methods available for a pivot table, as well as how they function so you can start thinking about how to select …