How to Choose the Right Chart to Visualize Your Data

Jami Oetting
Jami Oetting

Updated:

Published:

You overwhelmed with data -- data about website performance, sales performance, product adoption, customer service, marketing campaign results ... the list goes on. 

And when you manage multiple clients with multiple sources of data, things can becoming overwhelming quickly. What should you be tracking? What actually matters? How do you visualize and analyze the data so you can extract insights and actionable information? And more importantly, how can you make reporting more efficient when you are managing 10 clients?

One of the struggles that slows down my own reporting and analysis is understanding what type of chart to use and why. Even when I wrangle my data sets into an error-free spreadsheet, I'm left with questions about how to visualize it. I usually default to a pie chart or a column chart because I feel those are "safe" options. 

Download Now: An Introduction to Data Visualization for Marketers [Free Guide]

5 Questions to Consider When Choosing a Chart

Charts and graphs should clarify information. When you choose the wrong type of chart or simply default to the most common type of visualization, you could be going against this principle: you could either confuse the viewer or lead to mistaken data interpretation. 

Consider this chart from The New York Times' project on where people born in a state move to. It visualizes a large amount of data accumulated during more than 100 years. Yet, it is easy to understand, and it clearly highlights interesting trends.

dc-migration-nytimes

To create charts that clarify and provide the right canvas for analysis, you should first understand the reasons why you might need a chart. 

Consider these five questions when choosing a chart for your data:

1) Do you want to compare values?

Charts are perfect for comparing one or many value sets, and they can easily show the low and high values in the data sets. To create a comparison chart, use these types of graphs:

  • Column
  • Bar
  • Circular Area 
  • Line 
  • Scatter Plot
  • Bullet

2) Do you want to show the composition of something?

Use this type of chart to show how individual parts make up the whole of something, such as the device type used for mobile visitors to your website or total sales broken down by sales rep. 

To show composition, use these charts:

  • Pie
  • Stacked Bar
  • Stacked Column
  • Area
  • Waterfall

3) Do you want to understand the distribution of your data?

Distribution charts helps you to understand outliers, the normal tendency, and the range of information in your values. Use these charts to show distribution:

  • Scatter Plot
  • Line
  • Column
  • Bar

4) Are you interested in analyzing trends in your data set?

If you want to know more information about how a data set performed during a specific time period, there are specific chart types that do extremely well. You should choose a:

  • Line
  • Dual-Axis Line
  • Column

5) Do you want to better understand the relationship between value sets?

Relationship charts are suited to showing how one variable relates to one or numerous different variables. You could use this to show how something positively effects, has no effect, or negatively effects another variable. When trying to establish the relationship between things, use these charts:

  • Scatter Plot
  • Bubble
  • Line

13 Charts to Choose From When Analyzing Data

To better understand each chart and how they can be used, here's an overview of each type of chart:

Column

A column chart is used to show a comparison among different items, or it can show a comparison of items over time. You could use this format to see the revenue per landing page or customers by close date. 

column chart customers by close date

Bar

A bar chart, basically a horizontal column chart, should be used to avoid clutter when one data label is long or if you have more than 10 items to compare. This type of visualization can also be used to display negative numbers.

bar chart - customers by role

Line

A line chart reveal trends or progress over time and can be used to show many different categories of data. You should use it when you chart a continuous data set.

line chart - avg days to close

Dual Axis 

A dual axis chart allows you to plot data using two y-axes and a shared x-axis. It's used with three data sets, one of which is based on a continuous set of data and another which is better suited to being grouped by category. This should be used to visualize a correlation or the lack thereof between these three data sets. 

dual axis chart - revenue by new customers

Area

An area chart is basically a line chart, but the space between the x-axis and the line is filled with a color or pattern. It is useful for showing part-to-whole relations -- such as showing individual sales reps' contribution to total sales for a year. It helps you analyze both overall and individual trend information. 

area chart - users by lifecycle stage

Stacked Bar

This should be used to compare many different items and show the composition of each item being compared. 

stacked bar -mqls to sqls

Pie

A pie chart shows a static number and how categories represent part of a whole -- the composition of something. A pie chart represents numbers in percentages, and the total sum of all segments needs to equal 100%. 

pie chart - customers by role

Scatter Plot

A scatter chart will show the relationship between two different variables or it can reveal the distribution trends. It should be used when there are many different data points, and you want to highlight similarities in the data set. This is useful when looking for outliers or for understanding the distribution of your data. 

scatter-plot-customer-happines.png

Bubble

A bubble chart is similar to a scatter plot in that it can show distribution or relationship. There is a third data set, which is indicated by the size of the bubble or circle. 

bubble chart

Waterfall

A waterfall chart should be used to show how an initial value is affected by intermediate values -- either positive or negative -- and resulted in a final value. This should be used to reveal the composition of a number. An example of this would be to showcase how overall company revenue is influenced by different departments and leads to a specific profit number. 

 waterfall-chart

Chart via Baans Consulting

Funnel

A funnel chart shows a series of steps and the completion rate for each step. This can be used to track the sales process or the conversion rate across a series of pages or steps.

funnel chart - marketing

Bullet

A bullet graph reveals progress toward a goal, compares this to another measure, and provides context in the form of a rating or performance.

bullet-graph3.png

Heat Map

A heat map shows the relationship between two items and provides rating information, such as high to low or poor to excellent. The rating information is displayed using varying colors or saturation.  

heat-map-chart

DataHero is now a HubSpot integration partner. You can share customized dashboards and charts with HubSpot data and merged data from other business services. Check it out here

client-intake-download

Topics: Excel
We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Outline your company's marketing strategy in one simple, coherent plan.

Marketing software that helps you drive revenue, save time and resources, and measure and optimize your investments — all on one easy-to-use platform

START FREE OR GET A DEMO