Transpose a dataset

Transposing (or rotating) a dataset switches the values of the x- and y-axis. It re-alignes all values correctly as well.
Datawrapper enables to transpose both in step 2 and step 3, for all standard charts. 

The feature is shown in the two screenshots below. 

Look at the data in in column 1, where it says "Model". The model names (316i, etc.) are in column A, the specifications (Cubic Capacity) are in line 1. 

The values for the model are now in line 1, the specifications are in column A. 

This one-click switch is needed to display data properly for certain chart types. The best indicator that the order of your data causes visualization issues, is if a chart looks "funny". Try transposing or read specific tutorials for a chart type, where the most suitable data format is shown.

Note that if you transpose you will loose setting from step 2 (rounding, etc.)

With a bit of experience using chart types you will be able to prepare the data accordingly, even in Excel or Google Sheets. 
There are options to transpose data in both spreadsheet applications.

Further reading for advanced users 
It's good to compare as Datawrapper makes this task a one-click step, while in a spreadsheet software it is a little more complicated.

Transpose data in Excel
Transpose data in Google Sheets

Still need help? Contact Us Contact Us