Tables are different from graphs and charts. Charts are meant to present a quick, visual representation of data. But tables are drill-downs, an outlay of all the data down to their exact values or estimates. Tables are not always the right choice. If you have too much data, they look cluttered. But a well-designed table can help your reader find specific numbers and discover patterns and outliers.
There are three ways to make your tables into better visualizations.
First, follow some basic principles for clarity and simplicity in your table design. Separate headers and footers from the body of the table by using boldface or separating lines. Align numbers along the comma or decimal and avoid using heavy gridlines or too many gridlines. Consider using the appropriate level of precision—not every number needs four decimal points. And remove repetitive symbols like percentage and dollar signs; instead, put them in the subtitle or in the front row only.
Just following these first basic steps can help move a table from the blue version below to the one that follows:
Now that your table is stripped down to only what is essential, you can start adding elements back in strategically. Use colors or bolding to highlight outlier values or important trends to draw your reader’s eye to the important takeaways. Guiding your reader to the important numbers lets them answer their own questions about the data and better understand your argument. In these tables, for example, I highlight the few occurrences of negative values with colored text or cells.
Third, use other graph types within the table itself to simplify the table and make important values more obvious. Consider this dense table from the US Department of Agriculture. It shows the number of people who participate in the Food Distribution Programs on Indian Reservations. The data covers participation estimates for twenty-four states over fiscal years 2013 through 2016 and preliminary estimates for fiscal year 2017. Note the very dark, thick gridlines, which clutter the table and make it difficult to read.
We can fix this.
Instead of just including all of the numbers, let’s add some small graphs or icons to make the table more visual. Here are three ways we can make this table easier to read and navigate. One way is to convert it to a heatmap. Heatmaps use colors and color saturations to represent data values. Simply put, a heatmap is a table with color-coded cells. They are often used to visualize high frequency data or when seeing general patterns is more important than exact values. This is what the table looks like if we redesign it into a heatmap in which lighter shades encode smaller values and darker shades encode larger values.
Or we could use small bar charts or icons to illustrate a series. Quickly examining the original table, it’s tough to tell by how much program participation in Oklahoma exceeds the rest of the states. But if we add a small bar chart, the magnitude becomes much clearer. Or we could add an icon to mark increases or decreases over the entire period. The second table below does so by including an upward or downward triangle to the end of each row.
One last option is to add sparklines. Sparklines are small line charts that are typically used in data-rich tables, often at the end of a row or column. The purpose of sparklines is not necessarily to help the reader find specific values but instead to show general patterns and trends. Here, the sparklines show all five years of data, which allows us to omit three columns of numbers, lightening and simplifying the table. This approach lets us show the full time series in the sparklines while just showing the two endpoints in the table cells.
For anyone who wants to communicate their work quickly and accurately, presentation matters. Effective tables are well organized, reduce clutter, focus the reader’s attention on the important points, and often integrate visual components.
This post was originally published on the Cambridge Core blog on January 6, 2021.
If you would like to learn more about good table design and better data visualization approaches, check out my new book, Better Data Visualizations: A Guide for Scholars, Researchers, and Wonks.
Would be even more cool if you would label the first and last data point with the values in your table on the left!
If you’re referring to the last chart with the sparklines, you can add points to the first, last, high, or low points on the lines in Excel. I’m sure other tools allow this as well.
Thanks for reading!