How to create a short table
The short table you find in Datawrapper is internally named the "beautiful table". It is designed for use with a relatively small number of data points. In general, very often you can complement a data article with such a table, usually at the bottom of the test. The added quality is that your users can look up the precise numbers and values of different measure.
Consider adding a table in a post where you already have a bar chart or line chart - adding the table with the actual data is then an added level of service. Or, as a variation, you have the fastest growing companies in the US in a big bar chart, then you can add a table showing key figures for the ten biggest gainers and the ten biggest losers.
This guide will walk you through the steps to create an short table with Datawrapper.
1. Preparing and importing the data
Before uploading your data into Datawrapper, you should check if your dataset is formatted correctly. Since you're probably going for a 1:1 iteration of your data in your spreadsheet programme, these following steps are highly dependent on the nature of your data.
Here is how your data should be prepared in a spreadsheet:
- One header row containing categories
- The first column containing categorical dimensions
- Each following column containing values of measures accoring to their dimension
- Values of different dimensions/columns do not necessarily ahve to be of the same measures
Here is a table formatted as is shouldbe.
|Company||Last Sale||Change / Net %||Share Volume|
|Apple Inc.||136.53||-0.58 / -0.42||20,788,186|
|Alphabet Inc.||831.33||+0.57 / +0.07||1,472,771|
|Microsoft Coporation||64.62||+0.26 / +0.40||20,273,128|
You can copy this table from this post and import it into Datawrapper. Once that is done, click "Upload and continue" to get to step 2.
2. Check & Describe
In this step you have to check if Datawrapper copied your data correctly. If everything looks like it does in your spreadsheet programme, you're good to go.
Make sure that the box "First row as lable" is ticked so that Datawrapper correctly assigns the values to the labels. Click on "Proceed" and Datawrapper will take you to the next step.
The chart type to choose here is the " Short Table". Experienced users of Datawrapper will know that, but if you just started it is important to know that with the selection of this chart type the options and features available for this chart will change in the sections Refine, Annotate and Design. We cover this in a separate short tutorial found here.