How to create a short table (archived chart type)
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 a different measure.
If you're not sure if you should use the Long Table or the Short Table, consult this article.
This guide will walk you through the steps to create an short table with Datawrapper.
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. You can find some information about what defines "clean data" in this article.
Preparing and importing the data
If you want to create this chart type, your data needs to be in a certain format. You'll need:
- One header row containing descriptive labels ("Model", "Base Price", etc.)
- At least two columns with categories, numeric values or dates
All the columns you upload will also be displayed in your table. Note that only columns with numeric values can be displayed with an "inline bar chart", as in the chart above.
Here's the data we used to create the chart at the top of the page. You can find the dataset also in our data samples in step 1: Upload Data.
Model Base Price (US$, before incentives)
Range in miles
Tesla Model S 100D 94000 335 Tesla Model X 100D 96000 295 Chevrolet Bolt 37495 238 Tesla Model 3 35000 220 Nissan Leaf 30875 150 VW e-Golf 38000 125 BMW i3 44450 114
Source: Manufacturer's specifications
Once you prepared your data, create a new chart in Datawrapper. You can do so by going to our homepage and clicking on "Create a chart". In Step 1: Upload, copy & paste your dataset, upload it as a .csv or an Excel sheet. It will look like this:
Click "Proceed" at the bottom right to go to the next step:
Check & Describe
In the second step, you can check if your dataset was imported correctly and make changes to it - if necessary. If you did not upload a header row, you have to untick "First row as label" to avoid losing your first row of data. Always remember to do this if you don't have descriptive row and column headers.
In step 2, your data looks like this. You can see that Datawrapper correctly recognized your numbers as numbers (and not as text or dates) because they are colored in blue and are right-alined. To learn more about the Datawrapper's automatic recognition of data formats, visit this article.
Click on "Proceed" at the bottom left to go to Step 3: Visualize:
In this step, you see a first chart. It's probably a line chart. We want to change that. To do so, click on the "Short Table" symbol in the grid of available chart types:
You will now see a short table, without a title, descriptions or customized colors. Maybe you want to further refine, annotate & define this chart. We cover this in a separate short tutorial found here.