Genre Focus: Tables, Charts, & Diagrams


Video | Choosing a Chart | Principles | Survey of Chart Types | Building Charts | Checklist | Sources

In “Every Chart Type Ranked: What to Use and What to Avoid,” a data visualization instructor works through the common chart types and sorts the ones that communicate clearly from the ones that mostly decorate.


Choosing the Right Chart

A chart type is a tool for a job, and most jobs can be done by more than one tool.

Technical writing textbooks tend to sort visuals by the job they do. Concordia’s open text matches tables to precise values, bar graphs to category comparisons, line graphs to trends over an ordered sequence, stacked bars and pie charts to parts of a whole, and diagrams to mechanisms. Ohio State’s text pairs scatter plots with two numerical variables and bar graphs with a category and a number. Open Technical Communication says tables suit precise numbers, while charts sacrifice precision for impact.

The Reader’s Question Charts Often Used
“What’s the exact number?” Table
“Which is bigger?” Bar or column chart; sometimes a dot plot
“Is it going up or down?” Line chart; sometimes columns or an area chart
“What share of the whole?” Pie or donut chart; sometimes a stacked bar, waffle chart, or treemap
“How do these two things relate?” Scatter plot
“How do the parts add up to the total?” Waterfall chart
“Where is the value high or low?” Heatmap

Notice the overlap. A share of a whole can be shown with a pie, a stacked bar, a waffle chart, or a treemap. A trend can be a line or a set of columns, depending on whether you want the reader to see the shape or the individual periods. A heatmap, a bar chart, and a table can all answer the same question. The pairings above are starting points, not rules. The right choice depends on the message, the audience, and how much data there is.


Principles That Apply to Most Charts

A handful of habits improve almost every chart, whatever its type.

Principle Best Practice
Order logically Sort rankings from largest to smallest. Put time on the horizontal axis, moving left to right.
Label directly Identify the data where it sits: values at the ends of bars, series names beside lines. Readers should not need a legend to know what they are looking at.
Remove clutter Gridlines, borders, and decoration usually carry no information. Cut them.
Keep color simple Use one color for similar items. Spend a second color only on the part you want noticed, and mute the rest.
Annotate the context Mark the event, time period, or key number that explains the data, such as a shaded band or a note at the point where something changed.
Limit the categories Keep the number of slices, lines, and stacked layers low enough to read at a glance.
Add dimensions carefully Size, color, and shape can carry extra variables, but each one can complicate the message.

A Survey of Chart Types

Dozens of chart types exist. These are the ones worth recognizing, with a rating for how likely you are to use each at work.

Each chart gets one of four labels, based on two questions: is it useful (how likely you are to use it at work), and is it visually interesting?

All-Star Workhorse Show-off Forgettable
Useful and visually interesting Useful, but plain-looking. You can almost never go wrong with these. Visually interesting, but rarely useful Neither. Avoid these at all costs.
Butterfly Chart (Population Pyramid)
Candlestick Chart
Heatmap
Mekko (Marimekko) Chart
Pareto Chart
Scatter Plot
Stacked Area Chart
Waterfall Chart
100% Stacked Bar / Column
Area Chart
Bar / Column Charts
Clustered Bar / Column
Combination Chart
Gantt Chart
Line Chart
Pie Chart
Stacked Bar / Column
100% Stacked Area Chart
Bubble Chart
Chord Diagram
Diverging Bar Chart
Radar (Spider) Chart
Range Bar Chart (Football Field)
Ribbon Chart
Sankey Diagram
Sunburst Chart
Treemap
Bullet Chart
Donut Chart
Dot Plot
Histogram
Waffle Chart

100% Stacked Area Chart

Sample 100% Stacked Area Chart

Show-off

Primary role: Change over time

Summary: A 100% stacked area chart focuses entirely on how the makeup of the categories changes over time, which makes it useful for emphasizing metrics such as share. Use few categories, and make the message clear.

▼ Build it

▲ Back to survey list

100% Stacked Bar / Column

Sample 100% Stacked Bar / Column

Workhorse

Primary role: Compare categories

Summary: A 100% stacked chart shows the breakdown for each bar as a percentage, so you can clearly see the makeup of each question or period and even rank them. You can think of it as a set of pie charts stacked next to each other. It is also useful for showing how the makeup of a group changes over time.

▼ Build it

▲ Back to survey list

Area Chart

Sample Area Chart

Workhorse

Primary role: Change over time

Summary: An area chart is something like a line chart and a column chart combined. It shows the overall trend while still emphasizing the volume. Avoid using too many categories, and make sure the message is crystal clear. Area charts can look more interesting than lines or columns, but they are easy to misuse. If you only need the trend, a line chart is simpler. Google Sheets also offers a stepped area chart for values that hold steady and then change at set points, such as a rate or a price.

▼ Build it

▲ Back to survey list

Bar / Column Charts

Sample Bar / Column Charts

Workhorse

Primary role: Compare categories

Summary: Bar (horizontal) and column (vertical) charts compare categories by the length of their bars. Readers can compare lengths without worrying about any other dimension, so these suit rankings: even when the bars are close, it is clear which is longer. Order the categories logically, and sort rankings from largest to smallest. Use columns for change over time, because we read time from left to right. Put labels at the ends of the bars, remove the gridlines, and use one color unless you are trying to focus attention. They are the safest default for comparing categories. Use horizontal bars when the category labels are long, since they leave room for the text.

▼ Build it

▲ Back to survey list

Bubble Chart

Sample Bubble Chart

Show-off

Primary role: Relationships and distributions

Summary: A bubble chart is a scatter plot whose dot size carries a third variable. It needs much more care than a scatter plot, because the extra dimension can easily complicate the message.

▲ Back to survey list

Bullet Chart

Sample Bullet Chart

Forgettable

Primary role: Compare categories

Summary: A bullet chart shows progress toward a goal. It is plain and not that useful.

▲ Back to survey list

Butterfly Chart (Population Pyramid)

Sample Butterfly Chart (Population Pyramid)

All-Star

Primary role: Compare categories

Summary: A butterfly chart uses the same idea as a diverging bar chart, but the data is often symmetrical. Instead of comparing individual bars, the reader looks at the overall shape.

▲ Back to survey list

Candlestick Chart

Sample Candlestick Chart

All-Star

Primary role: Change over time

Summary: A candlestick chart shows how a stock’s price moves during a period. The thick body shows the opening and closing prices, and the thin lines (wicks) show the highest and lowest prices. Color shows the direction of the move.

▲ Back to survey list

Chord Diagram

Sample Chord Diagram

Show-off

Primary role: Flows and connections

Summary: A chord diagram shows relationships between different things. The visualization is usually too complicated and hard to understand.

▲ Back to survey list

Clustered Bar / Column

Sample Clustered Bar / Column

Workhorse

Primary role: Compare categories

Summary: A clustered chart groups bars by category so the subcategories can be compared side by side. It works like a normal bar chart, except the comparison is between subcategories within each group, such as several question types across regions.

▼ Build it

▲ Back to survey list

Combination Chart

Sample Combination Chart

Workhorse

Primary role: Change over time

Summary: A combination chart puts a line and columns in the same space. It is good for two types of data that are relevant to each other, such as counts and a rate. Make sure everything is clear and that the relationship is not too complicated.

▲ Back to survey list

Diverging Bar Chart

Sample Diverging Bar Chart

Show-off

Primary role: Compare categories

Summary: A diverging bar chart shows values for two separate variables extending out from a middle line. It is good for exploring the relationship between two variables across categories.

▲ Back to survey list

Donut Chart

Sample Donut Chart

Forgettable

Primary role: Parts of a whole

Summary: A donut chart is basically a pie chart without the center. It is mostly interchangeable with a pie chart, and the center can hold a title or a number. Because three-quarters or half of a circle is easy to recognize, a donut works well for a single headline share, such as 74%.

▼ Build it

▲ Back to survey list

Dot Plot

Sample Dot Plot

Forgettable

Primary role: Compare categories

Summary: A dot plot is like a scatter plot with discrete categories. It focuses on one dimension, so it is easy to understand.

▲ Back to survey list

Gantt Chart

Sample Gantt Chart

Workhorse

Primary role: Change over time

Summary: A Gantt chart shows project timelines and milestones. It is plain but common and can be very useful.

▲ Back to survey list

Heatmap

Sample Heatmap

All-Star

Primary role: Relationships and distributions

Summary: A heatmap measures data intensity. Think of a regular table that uses color to show high and low values. It is intuitive and gives a good visual overview, such as retail sales by category or AI adoption by industry and function. Label clearly what the colors mean, and avoid overloading the viewer with variables. If you are communicating a specific message, a bar chart, a line chart, or even a table can sometimes carry it more clearly.

▲ Back to survey list

Histogram

Sample Histogram

Forgettable

Primary role: Relationships and distributions

Summary: A histogram shows a frequency distribution. It looks like a column chart, but each column counts the number of occurrences within a range of values.

▲ Back to survey list

Line Chart

Sample Line Chart

Workhorse

Primary role: Change over time

Summary: A line chart puts an emphasis on change over time. A column chart focuses on each individual period; a line connects the data together, so it shows overall trends, patterns, and exceptions. It is also good for comparing the patterns of several categories, such as how spending differs between age groups. Label the lines directly instead of using a legend, and call out important sections, such as a time period or event that is relevant to the data. Excel also offers lines with markers, which suit a few data points where each reading matters, and stacked lines, which show running totals that readers often misread as actual values. Google Sheets offers a smooth line, which implies values between readings that were never measured.

▼ Build it

▲ Back to survey list

Mekko (Marimekko) Chart

Sample Mekko (Marimekko) Chart

All-Star

Primary role: Parts of a whole

Summary: A Mekko chart is like a 100% stacked column chart with an additional dimension: the widths of the columns also carry data. It can answer several questions in a single chart, such as who the biggest investors are and where each one puts its money, because every subcategory is visually proportional. Label what the axes mean, and use colors and outlines that make the subcategories distinct. It can confuse audiences, so it is not always useful.

▲ Back to survey list

Pareto Chart

Sample Pareto Chart

All-Star

Primary role: Compare categories

Summary: A Pareto chart is a bar chart that also shows how much each bar contributes to the total. The bars show counts, such as the number of people giving each reason for being late to work, and a line shows the cumulative percentage. It offers some of the benefits of a bar chart and a pie chart at once.

▲ Back to survey list

Pie Chart

Sample Pie Chart

Workhorse

Primary role: Parts of a whole

Summary: Pie charts get a lot of criticism, but used correctly they can be very useful. A pie shows the portion that one category makes up of the total. Avoid using it to compare the categories directly against each other; a bar or column chart does that better. Avoid comparing several pie charts against each other too. Keep the number of categories small and the colors minimal, and emphasize the category you are focusing on while muting the others. The eye cannot compare slice sizes as precisely as bar lengths, which is why bars win when the reader must compare.

▼ Build it

▲ Back to survey list

Radar (Spider) Chart

Sample Radar (Spider) Chart

Show-off

Primary role: Relationships and distributions

Summary: A radar chart plots data points on a set of axes that radiate from a central point, then connects the points. It can be useful when the message is obvious, but it has challenges. The order of the categories changes the shape of the web, and the categories are weighted equally even when they should not be compared with each other (sales, costs, profit, assets, and satisfaction, for example). A clustered column chart or a line chart often works better.

▲ Back to survey list

Range Bar Chart (Football Field)

Sample Range Bar Chart (Football Field)

Show-off

Primary role: Compare categories

Summary: In a range bar chart, the bars do not all start in the same place. Instead of comparing absolute values, you compare ranges. It is common in finance, where it shows the different valuations of a company from different methods. Some call it a football field chart.

▲ Back to survey list

Ribbon Chart

Sample Ribbon Chart

Show-off

Primary role: Change over time

Summary: A ribbon chart is like a stacked column chart, but the categories are ranked within each column, so you can see a category move up and down in rank over time. It is easy to misuse, because many categories make it complicated and it does not always depict the data accurately. A stacked bar chart or a line chart is usually better.

▲ Back to survey list

Sankey Diagram

Sample Sankey Diagram

Show-off

Primary role: Flows and connections

Summary: A Sankey diagram shows the flow of things, such as the breakdown of a company’s revenue. It is interesting to look at, but rarely appears in real presentations.

▲ Back to survey list

Scatter Plot

Sample Scatter Plot

All-Star

Primary role: Relationships and distributions

Summary: A scatter plot is a collection of dots, each plotted at an x and y coordinate. It shows the relationship between two variables, such as inventory turnover and profit margin. The relationship can be positive, negative, or absent. It can also show where one point sits among the others, such as one model of truck among its competitors. You can add variables by changing the size of the dots, the color, or the shape, but each addition can complicate the message. The simplest version is usually best. Both variables must be numbers. The scale of each axis affects how strong the relationship looks.

▼ Build it

▲ Back to survey list

Stacked Area Chart

Sample Stacked Area Chart

All-Star

Primary role: Change over time

Summary: A stacked area chart shows the overall trend and how each category contributes to the total. The focus is still on the overall trend, but unlike a line chart, the categories stack on top of each other, so it is easy to see each one’s contribution. Use few categories. Only the bottom layer sits on a common baseline, so readers can misjudge the size of the upper layers.

▼ Build it

▲ Back to survey list

Stacked Bar / Column

Sample Stacked Bar / Column

Workhorse

Primary role: Compare categories

Summary: A stacked chart shows the total of each bar and also its breakdown. Be careful not to tell a story about the breakdown. The total is what is easiest to see.

▼ Build it

▲ Back to survey list

Sunburst Chart

Sample Sunburst Chart

Show-off

Primary role: Parts of a whole

Summary: A sunburst chart is like a pie chart with multiple layers of category breakdowns. It is interesting but not always intuitive, and a treemap does much the same thing without the circle.

▲ Back to survey list

Treemap

Sample Treemap

Show-off

Primary role: Parts of a whole

Summary: A treemap shows the proportion that each category makes up of the total, like a Mekko chart, but it can nest categories and does not follow the same rigid dimensions. It is good for showing how one category fits within a larger group. Use color to separate groupings, or use size for one measure and color for another, as in a stock-market treemap where size shows trading volume and color shows change in value. Make sure the message is obvious. If you are comparing categories directly, a bar chart is better.

▲ Back to survey list

Waffle Chart

Sample Waffle Chart

Forgettable

Primary role: Parts of a whole

Summary: A waffle chart works like a pie chart, drawn as a grid of squares. It can be more fun to look at and sometimes easier to compare, something like a stacked column chart mixed with a pie chart.

▲ Back to survey list

Waterfall Chart

Sample Waterfall Chart

All-Star

Primary role: Parts of a whole

Summary: A waterfall chart is like a column chart whose pieces are separated into smaller floating values, so you can see how individual pieces build up to a total, such as the sources of capital for a project. Label the floating columns, add groupings or totals where possible, and be careful with color.

▲ Back to survey list


Building Charts in MS Excel or Google Sheets

Microsoft Excel and Google Sheets are the two most common places workplace charts get built.

Most offices run on one or the other, and both handle every chart below. Other tools are worth knowing, especially when you need a cleaner design or an interactive chart:

  • Datawrapper: free, quick, clean charts and maps, built for journalists.
  • Flourish: interactive and animated charts.
  • Canva: simple charts inside designed documents and graphics.
  • Tableau Public: dashboards and data exploration.

The steps below are for Google Sheets in a web browser and Excel for Microsoft 365 on Windows. Menus on a Mac or in older versions may differ slightly. In the steps, Insert > Chart means open the Insert menu (or ribbon tab), then choose Chart.

Column / Bar Charts , Line Charts , Area Charts , Pie / Doughnut Charts , Scatter Plots


Sample Column / Bar Charts

Column / Bar Charts

Rectangles whose length shows a value. Columns run up and down; bars run side to side.

GOOGLE SHEETS

1 Select the data, including the header row.
2 Insert > Chart. The Chart editor opens on the right.
3 Setup > Chart type: choose Column chart or Bar chart, or a stacked or 100% stacked version.
4 If the categories and series are swapped, check Setup > Switch rows / columns.
5 Customize > Series: check Data labels. Use Format data point to give one bar its own color.
6 Customize > Gridlines and ticks: turn off the major gridlines.
7 Customize > Chart & axis titles: type your takeaway as the chart title.

MICROSOFT EXCEL

1 Select the data, including the header row.
2 Insert > Insert Column or Bar Chart (Charts group), then choose clustered, stacked, or 100% stacked.
3 If the categories and series are swapped, choose Chart Design > Switch Row/Column.
4 Click Chart Elements (+) beside the chart: check Data Labels and clear Gridlines.
5 Click one bar twice to select it alone, then right-click > Format Data Point > Fill to give it its own color.
6 For a bar chart, right-click the vertical axis > Format Axis > check Categories in reverse order.
7 Click the chart title and type your takeaway.

PRO TIPS

  • Excel draws bar charts from the bottom up, so the first row of your data ends up at the bottom. Reversing the category order fixes a sorted ranking.
  • Sort the data in the spreadsheet (Data > Sort range in Sheets, Data > Sort in Excel). The chart follows the data, so sorting there is faster than rearranging the chart.
  • Excel’s default gap between bars is wide. Narrowing it (Format Data Series > Gap Width, around 50–80%) makes the bars read as solid shapes.
  • In a stacked chart, the first series sits on the axis and is the only one easy to compare. Put the segment that matters most first.
  • Start the value axis at zero. A truncated axis makes small differences look large.

▲ Back to build list   ▲ Back to survey list


Sample Line Charts

Line Charts

Points connected by a line, usually with time running along the bottom.

GOOGLE SHEETS

1 Select the data, with the dates or periods in the first column.
2 Insert > Chart, then Setup > Chart type > Line chart.
3 Customize > Series: pick a series to set its color and Line thickness. Add markers with Point size.
4 Customize > Legend > Position: move or remove the legend.
5 Customize > Gridlines and ticks: turn off the major gridlines.
6 Customize > Chart & axis titles: type your takeaway as the chart title.

MICROSOFT EXCEL

1 Select the data, with the dates or periods in the first column.
2 Insert > Insert Line or Area Chart > Line (or Line with Markers).
3 To label a line at its end, click the last point twice, then Chart Elements (+) > Data Labels. In Format Data Labels, check Series Name and clear Value.
4 Select the legend and press Delete once the lines are labeled.
5 Right-click a line > Format Data Series > Fill & Line: set the Width and Color.
6 Click the chart title and type your takeaway.

PRO TIPS

  • Format the time column as dates or text. If it holds plain numbers (2021, 2022), the program may plot it as a data series instead of the axis.
  • Leave missing values blank, not zero. A zero drags the line to the bottom of the chart. In Excel, set Chart Design > Select Data > Hidden and Empty Cells to show gaps.
  • Make the line that carries your message thicker (about 2.5–3 pt), and thin or gray the rest.
  • Spacing on the time axis should match real time. If periods are missing, the line will hide the gap unless the axis uses real dates.

▲ Back to build list   ▲ Back to survey list


Sample Area Charts

Area Charts

A line chart with the space beneath the line filled in. Stacked versions pile categories on top of each other.

GOOGLE SHEETS

1 Select the data, with the dates or periods in the first column.
2 Insert > Chart, then Setup > Chart type: choose Area, Stacked area, 100% stacked area, or Stepped area.
3 Customize > Series: set each layer’s color and Opacity.
4 Customize > Gridlines and ticks: turn off the major gridlines.
5 Customize > Chart & axis titles: type your takeaway as the chart title.

MICROSOFT EXCEL

1 Select the data, with the dates or periods in the first column.
2 Insert > Insert Line or Area Chart, then choose Area, Stacked Area, or 100% Stacked Area.
3 To change the stacking order, choose Chart Design > Select Data and use the up and down arrows beside the series.
4 Right-click a layer > Format Data Series > Fill: set its color and Transparency.
5 Click the chart title and type your takeaway.

PRO TIPS

  • Put the steadiest layer at the bottom. Every layer above it is measured from a wavy baseline, so a jumpy bottom layer distorts everything stacked on it.
  • In a standard (unstacked) area chart, later series can hide earlier ones. Use transparency or switch to stacked.
  • Use an area chart only when the horizontal axis is continuous, such as time. For separate categories, use columns.

▲ Back to build list   ▲ Back to survey list


Sample Pie / Doughnut Charts

Pie / Doughnut Charts

A circle divided into slices that add up to 100%. A doughnut is a pie with the center cut out.

GOOGLE SHEETS

1 Select one column of labels and one column of values.
2 Insert > Chart, then Setup > Chart type > Pie chart.
3 Customize > Pie chart > Donut hole: set a size to make a doughnut.
4 Customize > Pie chart > Slice label: choose Percentage.
5 Customize > Pie slice: pick a slice to change its color.
6 Customize > Chart & axis titles: type your takeaway as the chart title.

MICROSOFT EXCEL

1 Select one column of labels and one column of values.
2 Insert > Insert Pie or Doughnut Chart, then choose 2-D Pie or Doughnut.
3 Chart Elements (+) > Data Labels > More Options: check Percentage and clear Value.
4 Click one slice twice to select it alone, then right-click > Format Data Point > Fill to give it its own color.
5 For a doughnut, right-click the ring > Format Data Series > Doughnut Hole Size.
6 Click the chart title and type your takeaway.

PRO TIPS

  • Only use a pie when the values add up to a meaningful whole. Survey questions where people could choose more than one answer do not.
  • Sort the data from largest to smallest before building the chart, so the biggest slice starts at 12 o’clock and the rest run clockwise. In Excel, check Format Data Series > Angle of first slice is 0°.
  • Skip the 3-D options. A tilted pie distorts slice sizes.
  • Excel can label a doughnut’s hole with a text box (Insert > Text Box) placed over the chart. In Sheets, put the key number in the title or subtitle instead.

▲ Back to build list   ▲ Back to survey list


Sample Scatter Plots

Scatter Plots

Dots placed by two numbers: one sets how far across, the other how far up.

GOOGLE SHEETS

1 Select two columns of numbers. The first column becomes the horizontal (x) axis.
2 Insert > Chart, then Setup > Chart type > Scatter chart.
3 Customize > Series: check Trendline; under Label, you can show the equation or R².
4 Customize > Horizontal axis and Vertical axis: set the Min and Max values.
5 Customize > Chart & axis titles: add axis titles with units, and a takeaway title.

MICROSOFT EXCEL

1 Select two columns of numbers. The first column becomes the horizontal (x) axis.
2 Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter.
3 Chart Elements (+): check Axis Titles and Trendline. In Format Trendline, you can check Display R-squared value on chart.
4 Right-click an axis > Format Axis > Bounds: set the Minimum and Maximum.
5 Click the chart title and type your takeaway.

PRO TIPS

  • Put the variable you think drives the other on the x-axis, and the result on the y-axis.
  • Scatter axes do not need to start at zero. Set the bounds close to the data so the dots fill the space.
  • When dots pile on top of each other, make them smaller or partly transparent.
  • Show the R² value only to readers who know what it means.

▲ Back to build list   ▲ Back to survey list


Chart Checklist

Run through this list before you drop a chart into a document.

Check Look For
☐ The message You can state the takeaway in one sentence, and the title says it.
☐ The chart type The chart makes the reader compare the thing your message is about. Could a simpler chart or a table do the job?
☐ The order Rankings are sorted. Time runs left to right. Categories are in a logical order.
☐ The labels Values or labels are placed directly on bars and lines. Axes have titles and units. The legend is gone if direct labels replace it.
☐ The clutter Gridlines, borders, 3D effects, and anything that carries no information are removed.
☐ The color One main color, with one highlight. Meanings are consistent. Colors can be told apart in grayscale and by color-blind readers.
☐ The count Few categories. Pie charts have few slices (Ohio State suggests five or fewer). Area charts and treemaps are not crowded.
☐ The scale Bar chart axes start at zero. Scales do not exaggerate change.
☐ The callout The key number, period, or category is marked so the reader does not have to find it.
☐ The focus The chart carries one message. If it carries several, it is split.
☐ The explanation Axes, colors, and sizes are explained wherever the reader might wonder what they mean.
☐ The caption and source The chart has a number, a descriptive caption, and a source if the data is not yours.
☐ The print test It still works in black and white and at the size it will be printed.

Sources & Further Reading

Everything referenced above, if you want to go to the originals.