Try out the new Transpose before applying the changes

Charts now supports true data transposing, with changes being made to the actual file. Transpose used to be an irreversible change, but you can now preview results in a popup screen before applying the change, and go back and adjust data as many times as you need until you’re happy with the chart preview.