Which Type of Chart or Graph is Right for You?
You’ve got data and you’ve got questions, but what's the best way to visualize that data to get the answers you need? Transforming data into an effective visualization or dashboard is the first step towards making your data make an impact.
As Henry D. Hubbard, Creator of the Periodic Table of Elements said, “There is magic in graphs. The profile of a curve reveals in a flash a whole situation — the life history of an epidemic, a panic, or an era of prosperity. The curve informs the mind, awakens the imagination, convinces.”
Bar charts are one of the most common data visualizations. You can use them to quickly compare data across categories, highlight differences, show trends and outliers, and reveal historical highs and lows at a glance. Bar charts are especially effective when you have data that can be split into multiple categories. For example, volume of shirts in different sizes, website traffic by referrer, or percent of spending by department.
- Add color to bars for more impact. Color adds a quick, visual identifier that makes comparisons easy.
- Use stacked bars or side-by-side bars. Stacked and side-by-side bar charts let you break down your data even further, giving more depth to your analysis.
- Combine bar charts with maps. Maps are a powerful and intuitive way to visualize data. Using a map as a filter lets viewers drill down and find detailed answers.
- Put bars on both sides of an axis. Plotting positive and negative data points along the same axis makes trends and outliers stand out.
The line chart, or line graph, connects several distinct data points, presenting them as one continuous evolution. Use line charts to view trends in data, usually over time (like stock price changes over five years or website page views for the month). The result is a simple, straightforward way to visualize changes in one value relative to another. But line charts aren’t limited to time. Any dimension—like date types, time intervals, and other ordinal data—can be used as the horizontal axis.
- Combine a line graph with bar charts. Bar and line charts go well together. Showing two kinds of information on the same axis adds powerful context to your data.
- Shade the area under lines. Shading the area under line charts provides an immediate visual cue of quantity, and can improve the look and feel of your graph. When your graph includes multiple lines, use multiple colors to inform the viewer of each line’s relative contribution to the whole.
Pie charts are powerful for adding detail to other visualizations. Alone, a pie chart doesn’t give the viewer a way to quickly and accurately compare information. Since the viewer has to create context on their own, key points from your data are missed. Instead of making a pie chart the focus of your dashboard, try using them to drill down on other visualizations. This approach uses the pie chart’s simplicity to add information, without distracting from the larger picture.
Maps are a no-brainer for visualizing any kind of location information, whether it’s postal codes, state abbreviations, country names, or your own custom geocoding. If you have geographic information associated with your data, maps are a simple and compelling way to show how location correlates with trends in your data. For example, insurance claims by state, product export destinations by country, car accidents by zip code, and custom sales territories.
- Use a map as a filter for other types of charts, graphs, and tables. A map provides an intuitive way to drill down into your data. Viewers can see large trends at a glance, and use
filter actions to quickly investigate even further.
- Layer data points on top of maps. Marks can be overlaid on a map to show individual data points with more precision. Try varying their size to add more visual detail to your analysis.
Density maps reveal patterns or relative concentrations that might otherwise be hidden due to an overlapping mark on a map—helping you identify locations with greater or fewer numbers of data points. Density maps are most effective when working with a data set containing many data points in a small geographic area.
- Use Pages to understand spatial patterns.. With the Pages shelf in Tableau, you can move
through the years, months, or days to see how the data changes over time and you can see
relative comparisons as you animate the data.
- Use a background image to provide context. If you’re using a non-traditional map (like a map of a tennis
court, for example), make sure you use a relevant background image to ground the data in context.
Scatter plots are an effective way to investigate the relationship between different variables, showing if one variable is a good predictor of another, or if they tend to change independently. A scatter plot presents lots of distinct data points on a single chart. The chart can then be enhanced with analytics like cluster analysis or trend lines. For example, you could use this chart to visualize technology early-adopters’ and laggards’ purchase patterns or shipping costs of different product categories to different regions.
- Use cluster analysis to identify segments. Cluster analysis groups data points into distinct segments, based on the variables you select.
- Use highlight actions. By adding a highlight action to your scatter plots, quickly see which points have attributes in common, without losing sight of the rest of the dataset.
- Use custom mark types. Custom marks add a quick visual cue to your chart, clearly distinguishing different groups of points.
Gantt charts display a project schedule or show changes in activity over time. A Gantt chart shows steps that need to be completed before others can begin, along with resource allocation. But Gantt charts aren’t limited to projects. You can represent any data related to a time series with this chart type, like the duration of a machine’s use or availability of players on a team, for example.
- Add color. Changing the color of the bars within the Gantt chart quickly informs viewers about key aspects of the variable.
- Combine maps and other chart types with Gantt charts. Including Gantt charts in a dashboard with other chart types can help correlate otherwise disconnected data.
Although bubbles aren’t technically their own type of visualization, using them as a technique adds detail to scatter plots or maps to show the relationship between three or more measures. Varying the size and color of circles creates visually compelling charts that present large volumes of data at once.
- Add color. Color can add more dimension to a bubble chart, while creating an attractive visual “pop.”
- Overlay bubbles on maps. Bubbles quickly inform a viewer about relative concentration of data. Using these as an overlay puts geographically-related data in context for the viewer.
Histograms show how your data is distributed across distinct groups. Histograms group your data into specific categories (also known as “bins”), then assign a bar that is proportional to the number of records in each category. You could use this chart type to visualize things like number of customers by company size, student performance on an exam, or frequency of a product defect.
- Test different groupings of data. Creating a variety of histograms can help to determine useful groupings of data.
- Add color to break bins down. Apply color to bars representing each group to show a second set of categories on the same chart.
With bullet charts, quickly compare progress against a goal. At its core, a bullet graph is a variation of a bar chart. Designed to replace dashboard gauges, meters, and thermometers, a bullet chart shows more information and provides more points of comparison, while using less space. Because it doesn’t display history, this chart is best suited for quick “how are we doing” dashboards, rather than deep analysis.
- Use color to illustrate achievement thresholds. Including color as a backdrop gives the viewer another reference to better understand how performance is measured against goals.
- Add bullets to dashboards for summary insights. Combining bullets with other chart types into a dashboard supports productive discussions around where to focus efforts to accomplish objectives.
Highlight tables take heat maps one step further. A highlight table uses color to grab the viewer’s attention, while still presenting precise figures. For example, segmentation analysis of target market, product adoption across regions, and sales leads by individual representative.
- Combine highlight tables with other chart types. Buttressing a line chart with a highlight table, for example, lets a viewer keep overall data trends in mind while drilling down into specific cross sections of interest.
Treemaps relate different segments of your data to the whole. As the name of the chart suggests, each rectangle in a treemap is subdivided into smaller rectangles, or sub-branches, based on its proportion to the whole. They make efficient use of space to show percent total for each category.
- Color the rectangles by category. Because treemaps are such a dense chart type, color makes it easier for the viewer to distinguish one category from another.
- Combine treemaps with bar charts. The bar chart lets the viewer quickly compare items through the bar’s length, while also showing the breakdown of categories within each bar.
Box-and-whisker plots, or boxplots, are a common way to show distributions of data. The name refers to the two parts of the diagram: the box, which contains the median of the data along with the 1st and 3rd quartiles (25% greater and less than the median), and the whiskers, which typically represent data within 1.5 times the interquartile range (the difference between the 1st and 3rd quartiles). The whiskers can also be used to show the maximum and minimum points within the data.
- Hide the points within the box. This helps the viewer focus on the outliers.
- Compare box plots across categorical dimensions. Box plots are great for quickly comparing distributions between datasets.
Though candlestick charts may remind you of box-and-whisker plots, they mean different things. Candlestick charts are commonly used for financial analysis to show metrics about a financial instrument over a period of time. This chart type shows the open, close, high, and low values of an instrument over time, in an easy to understand format.
- Present multiple separate candlestick charts. Trying to layer too many data points on a single chart can be confusing and difficult to navigate. Creating clear distinctions helps the viewer to analyze the charts separately.
- Use highlight actions to correlate data. Time-series data can be difficult to keep track of. Highlight actions allow a user to focus on a single date, while still seeing the historical information in the rest of the chart.