Skip main navigation

What visualization should I use?

With so many charts and visualizations available, it is important to select the right one. Find out what chart to use in Paula's article below.
question mark
© paula guilfoyle

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 able to understand the report. And they might miss important information.

Different types of information and data need different types of charts. You can use the lists below to help you select the right type of chart for the right type of data or story.

Comparisons: Clustered Bar/Column Charts, Stacked and 100% stacked Bar/Column Charts, gauges, radar charts, and bubble charts.

Change over time: Line charts, sparklines, area and stacked area charts, Gantt charts, Waterfall charts, and line with column combination charts.

Subsets of Data: Pie charts, donut charts, treemaps, stacked area charts, sunbursts, pyramid 3D, waterfall charts, stacked and 100% stacked bar and column charts.

Relationships and Flow: Funnel charts, chord, and network navigator.

Rankings: Clustered Bar/Column charts, multirow cards, tables, and matrixes.

Location-based: Maps, ArcGIS Maps, filled maps, and shape maps Correlation: Scatter charts, Line and clustered column charts, stacked column charts, table heatmaps

© paula guilfoyle
This article is from the free online

Introduction to Excel Charts for Data Visualisation

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education