Skip main navigation
Home Introduction to Excel Charts for Data Visualisation

Course: Introduction to Excel Charts for Data Visualisation

Inserting Sparklines

In the week 4 workbook, you will find the data to work along with me in this video. Make sure you can set up sparklines before we move on to …

Chart templates

In the workbook you downloaded for this week, you will find a worksheet named Chart template data. You can use the data in this worksheet to create and save a …

Formatting Scatter charts

Using the scatter charts you created in the last step, you can now add some formatting and a trendline. Explore all the formatting options to make sure you are familiar …

Inserting Bubble charts

You will find the data for this video in the workbook you downloaded at the start of this week. The week 3 workbook. Make sure you can practice along with …

Limitations of Waterfall charts

Use the comments section below to record your key takeaways from this video. recording your takeaways in the way will help to reinforce the learning. List out as many limitations …

Scatter charts and correlation

What are Scatter Plots? A Scatter plot is used to visualize relationships between two or more variables. A relationship between two values is known as correlation. You can have a …

Examples of bad data visualizations

This pie chart was used in a presentation to show the US smartphone market share. Apple and the iPhone at the time having 19.5% of the market share. However, when …

What visualization should I use?

A good visualization is one where the user, without any prior knowledge, can quickly understand the story it is telling. Get the visualizations wrong and the user will not be …

Waterfall charts

A waterfall chart is used to visualize how the starting value of something (say a bank account) gets to the end value (balance at the end of the month). This …
These articles are from the online course:

Introduction to Excel Charts for Data Visualisation

Join Now