Transpose columns to rows in Grapher's worksheet

This article provides steps for how to convert columns to rows or rows to columns using the Data Tools | Data | Transpose command in Grapher's worksheet.

Grapher 14 can read data from rows once data is plotted, but previous versions required that data be in columns to create most plots. If your data is in rows, you can use Grapher's worksheet to quickly transpose rows to columns, or vice versa. 


To transpose data in Grapher:

  1. Click the File | Open command.
  2. Select the worksheet and click Open.
  3. Click the left mouse button and select the first cell.
  4. Hold down the left mouse button and highlight all of the cells that should be transposed.

Grapher's worksheet with columns highlighted
Highlight the portion of the worksheet that should be flipped.

  1. Click the Data Tools | Data | Transpose command. The columns become rows and the rows become columns.

Result of using the Data Tools | Data | Transpose command
The worksheet updates with the flipped data.


Updated September 20, 2018

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.