Multiple x and y columns

[thopaParticipant]

Hi,

I’ve got a question about a series of plots and how to use a color gradient.

I regularly need to work with data sets that include a column for x values and a column for y values but a lot for different time points. This means I need to plot for example 120 plots each with a separate x column and y column. I know that it is easy to create a group of plots with the plots command. But as far as I understood, this command used only one column for the x values, so that is not an option. Is the only way to select 120 times a pair of x and y columns and use the single plot command? Another request would be to use a color gradient from the first plot to the last.

 

Is there an option in DataGraph for an easy way to handle such data?

 

Thanks in advance

Thomas

 

[pamelaModerator]

To easily plot these you would need to append the data into one column.  Is there any possibility of generating the data differently so you can more easily append the data?

For example, if you have each x y set of data saved in individual CSV files where the column headings would be the same, but each file name would identify the data.  If so,  you can import all the data at once by dragging and dropping all the files at once onto the  column list.  Then each x-y pair would be in its own group.

By then placing all the groups in a higher level group, you can use the gear menu on the highest group to append all the data at once.

That creates the appended set of data that can be plotted with one Points command, where you can have the color of the point vary.

Otherwise, you would need individual Points command for each one x,y column and the colors would have to be set individually.

 

[thopaParticipant]

Thanks for your help.

I managed to organize the data in several groups and used the append subgroups command to create flat columns that I can plot with the points command.

Now I noticed that DataGraph has problems with creating a color scheme for the amount of data. Do I need to assign the colors in the scheme manually for the “Name” column in my example? Letting DataGraph do this was always very easy for the user. But I have never tried this with this amount of data.

 

[thopaParticipant]

I answered this question myself. I should change the text “Name” column to a number column in order to let DataGraph create a color scheme for the different values.

My fault.

Thanks a lot for your help.

[Author]

Posts