There are options to transpose data in both spreadsheet applications, although they tend to be a bit more complicated than to transpose the data in Datawrapper. With a bit of experience using chart types, you will be able to prepare the data accordingly, even in Excel or Google Sheets. Note that if you transpose in step 3, you will lose setting from step 2 (rounding, etc.) In step 3: Visualize, you can transpose the data by clicking on the blue text in the hint that you can find below the chart types: you can also click on the button 'Swap rows and columns (transpose)' at the bottom of the page: After that, right-click on the cell, highlight Paste Special, and choose Transpose. Then, select the most top-left cell where you want to put your transposed result.

Then, press the Ctrl + C buttons so the cell range will be in a copy mode like this. In step 2: Check & Describe, you can click on the arrow in the left top corner of your table to transpose your data: To paste transpose, first, highlight the cell range you want to transpose. Often, when your chart looks funny, all you need to do is to transpose the data:īecause transposing is so essential to having the data appear the way you want it to in your visualization, Datawrapper gives you three ways to transpose your data in the chart editor: two in step 2 and one in step 3. Why transpose data?įor many chart types in Datawrapper, transposing a table means that the x-axis and y-axis swap. The dollar values in the second column moved into the second row, and the taste assessments in column 3 became the third row. You can see that the names in column 1 became the first row in the transposed table. Let's say we have the following table: BlueberriesĪfter transposing, it will become this table: Blueberries Transposing a dataset means swapping its rows and columns so that the rows become columns and the columns become rows

Where is the transpose button in excel