Plotting selected row(s) from 2D data

[redhykaParticipant]

I have 2D data with many rows and colums  look like this (in excel) :

Is it possible plot line only selected row(s) for data in all columns?
I found mask but, it is exhaustive to create for each column one by one.

Thanks.

Grace

• This topic was modified 2 years, 5 months ago by redhyka. Reason: clarification

[redhykaParticipant]

Nevermind, I found a solution.

I flattened all the columns , and then plot the value vs category, and then mask using the selected row(s)

[davidwhiteman@mac.comParticipant]

Good. Sounds like you found a solution. Here is another way. Select the x and y columns to be plotted and use the Plots command and its Mask sub-command as shown in the following figure in which the # column is used to select the rows of interest:

Hope this helps.

-Dave Whiteman

[dgteamModerator]

Just wanted to point out the “Plot” command would require the flat format and then mask as needed.  And the “Plots” command, as shown nicely above, can work with a wide format.

For anyone that wants to learn about the difference in formats see: How to flatten data.

[Author]

Posts