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 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
Introduction to Excel Charts for Data Visualisation
Introduction to Excel Charts for Data Visualisation
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
