🧵 Using the Export Data dialog to reformat and plot in Excel
Step 1.
Export the text file with values of the DLC_Tongue spline (11 xy pairs in a row for each time point)
| x | y | x | y | x | y | x | y | x | y | x | y | x | y | x | y | x | y | x | y | x | y |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49.7 | -5.0 | 37.7 | 1.5 | 24.8 | 5.5 | 11.7 | 11.8 | -2.7 | 13.4 | -16.1 | 7.4 | -26.7 | -9.6 | -30.1 | -24.5 | -37.5 | -31.4 | -43.6 | -39.5 | -48.3 | -48.5 |
| 48.1 | -7.4 | 36.6 | -1.2 | 24.5 | 4.2 | 11.8 | 12.7 | -2.6 | 12.8 | -16.1 | 7.4 | -20.3 | -21.5 | -20.3 | -37.1 | -25.7 | -42.1 | -30.1 | -48.0 | -33.5 | -54.5 |
| 48.7 | -6.4 | 37.1 | -0.1 | 24.5 | 4.2 | 11.8 | 12.4 | -2.7 | 13.0 | -16.2 | 7.7 | -20.6 | -21.0 | -20.9 | -36.3 | -25.5 | -42.2 | -30.0 | -48.1 | -33.3 | -54.6 |
| 47.9 | -7.7 | 36.5 | -1.3 | 24.4 | 3.8 | 11.8 | 12.7 | -2.6 | 12.7 | -16.1 | 7.4 | -21.4 | -19.5 | -21.8 | -35.1 | -24.7 | -42.9 | -29.0 | -48.6 | -32.3 | -55.0 |
| 47.7 | -8.0 | 36.3 | -1.7 | 24.3 | 3.4 | 11.8 | 12.8 | -2.6 | 12.6 | -16.2 | 8.0 | -20.8 | -20.5 | -21.6 | -35.4 | -25.0 | -42.7 | -29.4 | -48.5 | -32.7 | -54.9 |
| 48.9 | -6.2 | 37.2 | 0.1 | 24.7 | 4.9 | 11.9 | 13.6 | -2.6 | 12.7 | -15.9 | 6.7 | -27.2 | -8.6 | -28.3 | -26.8 | -35.3 | -33.4 | -41.1 | -41.0 | -45.5 | -49.6 |
| 49.2 | -5.8 | 37.4 | 0.6 | 24.8 | 5.5 | 11.8 | 13.2 | -2.6 | 12.9 | -15.9 | 6.8 | -28.4 | -6.4 | -27.8 | -27.5 | -34.7 | -33.9 | -40.4 | -41.5 | -44.7 | -49.9 |
| 49.1 | -5.8 | 37.4 | 0.6 | 24.8 | 5.3 | 11.8 | 12.8 | -2.6 | 12.5 | -16.0 | 7.0 | -28.1 | -6.9 | -29.1 | -25.9 | -36.2 | -32.6 | -42.2 | -40.4 | -46.7 | -49.1 |
| 48.5 | -6.8 | 36.9 | -0.4 | 24.6 | 4.7 | 11.8 | 13.0 | -2.6 | 12.5 | -16.0 | 7.0 | -28.4 | -6.4 | -30.8 | -23.6 | -38.4 | -30.6 | -44.6 | -38.9 | -49.3 | -48.0 |
| 48.3 | -7.1 | 36.8 | -0.7 | 24.6 | 4.5 | 11.8 | 12.8 | -2.6 | 12.7 | -16.1 | 7.4 | -28.8 | -5.6 | -30.6 | -23.9 | -38.1 | -30.9 | -44.3 | -39.1 | -48.9 | -48.2 |
| 48.0 | -7.5 | 36.5 | -1.3 | 24.5 | 4.1 | 11.8 | 12.4 | -2.6 | 12.3 | -16.0 | 7.2 | -27.9 | -7.3 | -28.4 | -26.7 | -35.4 | -33.3 | -41.3 | -41.0 | -45.7 | -49.5 |
| 47.3 | -8.6 | 36.1 | -2.3 | 24.3 | 3.3 | 11.8 | 12.5 | -2.6 | 12.4 | -16.1 | 7.3 | -28.3 | -6.6 | -29.9 | -24.8 | -37.2 | -31.7 | -43.3 | -39.7 | -47.9 | -48.6 |
| 48.0 | -7.5 | 36.6 | -1.2 | 24.5 | 4.2 | 11.8 | 12.5 | -2.6 | 12.4 | -16.1 | 7.4 | -28.0 | -7.0 | -27.6 | -27.7 | -34.5 | -34.2 | -40.1 | -41.7 | -44.4 | -50.0 |
| 47.3 | -8.7 | 36.1 | -2.4 | 24.3 | 3.3 | 11.8 | 12.5 | -2.6 | 12.7 | -16.1 | 7.5 | -28.6 | -6.1 | -30.6 | -23.9 | -38.1 | -30.9 | -44.3 | -39.1 | -49.0 | -48.2 |
| 47.9 | -7.7 | 36.5 | -1.4 | 24.4 | 4.0 | 11.8 | 12.3 | -2.6 | 12.3 | -16.0 | 7.2 | -28.2 | -6.8 | -30.7 | -23.8 | -38.2 | -30.8 | -44.4 | -39.0 | -49.1 | -48.1 |
| 48.6 | -6.6 | 37.0 | -0.3 | 24.4 | 3.9 | 11.8 | 12.4 | -2.6 | 12.6 | -16.1 | 7.5 | -28.7 | -5.9 | -31.3 | -23.0 | -39.0 | -30.1 | -45.3 | -38.4 | -50.0 | -47.7 |
| 47.8 | -7.9 | 36.4 | -1.5 | 24.5 | 4.1 | 11.8 | 12.5 | -2.6 | 12.6 | -16.0 | 7.3 | -28.2 | -6.7 | -29.6 | -25.2 | -36.9 | -32.0 | -42.9 | -39.9 | -47.4 | -48.8 |
| 47.7 | -7.9 | 36.4 | -1.6 | 24.5 | 4.0 | 11.7 | 11.9 | -2.6 | 12.3 | -16.0 | 7.1 | -28.2 | -6.8 | -30.3 | -24.2 | -37.8 | -31.2 | -43.9 | -39.3 | -48.6 | -48.3 |
| 48.8 | -6.4 | 37.1 | 0.0 | 24.5 | 4.3 | 11.7 | 11.9 | -2.6 | 12.3 | -16.0 | 7.2 | -28.3 | -6.5 | -30.0 | -24.6 | -37.4 | -31.5 | -43.5 | -39.6 | -48.1 | -48.5 |
| 47.7 | -8.1 | 36.3 | -1.7 | 24.5 | 4.0 | 11.7 | 11.9 | -2.6 | 12.4 | -16.0 | 7.0 | -28.1 | -6.9 | -29.5 | -25.3 | -36.8 | -32.1 | -42.8 | -40.0 | -47.3 | -48.9 |
| 48.9 | -6.2 | 37.2 | 0.1 | 24.5 | 4.4 | 11.7 | 11.6 | -2.6 | 12.4 | -16.1 | 7.4 | -28.4 | -6.3 | -28.7 | -26.3 | -35.8 | -33.0 | -41.7 | -40.7 | -46.1 | -49.4 |
| 48.0 | -7.5 | 36.6 | -1.1 | 24.5 | 4.4 | 11.7 | 11.6 | -2.6 | 12.4 | -16.1 | 7.4 | -28.5 | -6.3 | -31.4 | -22.9 | -39.0 | -30.0 | -45.3 | -38.4 | -50.1 | -47.7 |
| 47.2 | -8.7 | 36.0 | -2.6 | 24.3 | 3.4 | 11.7 | 11.5 | -2.6 | 12.5 | -16.1 | 7.4 | -28.5 | -6.2 | -30.0 | -24.6 | -37.4 | -31.5 | -43.5 | -39.5 | -48.1 | -48.5 |
| 47.2 | -8.8 | 35.9 | -2.7 | 24.3 | 3.5 | 11.8 | 12.0 | -2.6 | 12.4 | -16.0 | 7.1 | -28.1 | -6.9 | -30.4 | -24.1 | -37.9 | -31.1 | -44.1 | -39.2 | -48.7 | -48.3 |
| 47.3 | -8.6 | 36.0 | -2.5 | 24.3 | 3.5 | 11.7 | 11.5 | -2.6 | 12.6 | -16.0 | 7.2 | -28.4 | -6.5 | -29.5 | -25.3 | -36.8 | -32.1 | -42.8 | -40.0 | -47.3 | -48.8 |
| 47.1 | -8.8 | 36.0 | -2.6 | 24.4 | 3.7 | 11.8 | 12.0 | -2.6 | 12.6 | -16.1 | 7.4 | -28.5 | -6.2 | -31.4 | -22.9 | -39.0 | -30.1 | -45.3 | -38.4 | -50.1 | -47.7 |
| 48.4 | -6.9 | 36.8 | -0.6 | 24.4 | 3.6 | 11.8 | 12.3 | -2.6 | 12.6 | -16.0 | 7.1 | -28.6 | -6.1 | -31.6 | -22.6 | -39.3 | -29.8 | -45.6 | -38.2 | -50.4 | -47.6 |
| 48.0 | -7.6 | 36.5 | -1.4 | 24.2 | 2.8 | 11.8 | 12.3 | -2.6 | 12.3 | -15.9 | 6.9 | -28.7 | -5.9 | -31.5 | -22.7 | -39.2 | -29.9 | -45.5 | -38.3 | -50.4 | -47.6 |
| 48.1 | -7.4 | 36.6 | -1.2 | 24.2 | 3.0 | 11.8 | 12.4 | -2.6 | 12.2 | -15.7 | 6.2 | -28.4 | -6.4 | -32.0 | -22.1 | -39.8 | -29.3 | -46.2 | -37.8 | -51.1 | -47.3 |
| 47.9 | -7.7 | 36.5 | -1.5 | 24.1 | 2.7 | 11.8 | 12.3 | -2.6 | 12.3 | -15.8 | 6.4 | -28.5 | -6.3 | -29.6 | -25.1 | -36.9 | -31.9 | -43.0 | -39.9 | -47.5 | -48.8 |
| 48.2 | -7.2 | 36.7 | -0.9 | 24.3 | 3.3 | 11.7 | 11.3 | -2.6 | 12.3 | -15.8 | 6.5 | -28.2 | -6.7 | -30.1 | -24.6 | -37.4 | -31.5 | -43.5 | -39.5 | -48.2 | -48.5 |
| 49.2 | -5.7 | 37.4 | 0.7 | 24.7 | 5.0 | 11.7 | 11.1 | -2.5 | 11.8 | -15.9 | 6.8 | -28.5 | -6.2 | -30.3 | -24.3 | -37.7 | -31.2 | -43.8 | -39.3 | -48.5 | -48.4 |
| 48.8 | -6.3 | 37.1 | 0.1 | 24.5 | 4.4 | 11.7 | 10.5 | -2.5 | 11.8 | -15.9 | 6.8 | -28.7 | -5.8 | -31.7 | -22.5 | -32.5 | -35.9 | -38.0 | -43.0 | -42.1 | -51.0 |
| 49.6 | -5.2 | 37.7 | 1.3 | 24.8 | 5.6 | 11.6 | 10.3 | -2.5 | 11.8 | -16.0 | 6.9 | -28.7 | -5.8 | -32.3 | -21.7 | -35.1 | -33.6 | -40.8 | -41.2 | -45.2 | -49.7 |
| 49.9 | -4.7 | 37.9 | 1.9 | 25.0 | 6.2 | 11.6 | 10.1 | -2.5 | 11.9 | -16.2 | 7.8 | -29.3 | -4.7 | -32.3 | -21.8 | -35.8 | -33.0 | -41.6 | -40.7 | -46.1 | -49.4 |
| 49.3 | -5.5 | 37.5 | 0.9 | 24.8 | 5.3 | 11.7 | 10.7 | -2.6 | 12.4 | -16.2 | 7.6 | -29.0 | -5.3 | -32.3 | -21.7 | -32.7 | -35.8 | -38.1 | -43.0 | -42.2 | -51.0 |
| 50.1 | -4.4 | 38.1 | 2.2 | 25.1 | 6.7 | 11.7 | 10.7 | -2.5 | 11.9 | -15.9 | 6.8 | -28.9 | -5.4 | -33.1 | -20.7 | -34.9 | -33.7 | -40.7 | -41.3 | -45.0 | -49.8 |
| 49.8 | -4.8 | 37.8 | 1.7 | 24.9 | 5.9 | 11.6 | 9.6 | -2.5 | 11.9 | -16.2 | 7.9 | -28.8 | -5.7 | -30.7 | -23.7 | -38.3 | -30.7 | -44.5 | -38.9 | -49.2 | -48.1 |
| 49.8 | -4.8 | 37.9 | 1.7 | 25.0 | 6.1 | 11.6 | 10.2 | -2.6 | 12.4 | -16.3 | 8.2 | -28.7 | -5.8 | -25.9 | -29.9 | -32.5 | -36.0 | -37.9 | -43.1 | -41.9 | -51.1 |
| 49.4 | -5.4 | 37.6 | 1.1 | 24.8 | 5.4 | 11.6 | 10.3 | -2.6 | 12.6 | -16.5 | 8.8 | -28.4 | -6.4 | -31.8 | -22.4 | -39.5 | -29.6 | -45.9 | -38.0 | -50.7 | -47.5 |
Right click on the text file and select Open with… then select excel. Alternatively open excel and the click File|Import and select the txt file. It should look like below.
Step 2. Transpose the data
Select all the data and < Ctrl> C to copy it all to the clipboard.
Then open a new Sheet using the + symbol at the bottom of the speadsheet.
Select the A1 cell in the new Sheet
And click the Paste button in the Home tab. Then click the transpose option (circled red below)
Step 3. Separate the table into x and y alternating columns
Select cell A1and enter the following formula
=INDEX(Sheet2!$A$1:$BT$22,ROW(Sheet2!$A1)*2-1+ --(ISEVEN(COLUMN(Sheet2!A$1))), CEILING.MATH(COLUMN(Sheet2!A$1)/2))
Then click and drag the surrounding box using the little square in the bottom right corner of the cell, to extend the formula over the entire range of 22 rows and N columns
Step 4 Plot the Tongue curve
Select the set of x/y columns and in the Inset options at the top select ”more scatter charts” Then sect the line option and the options shown below
This should provide a plot as below
Select the Legend and delete
