Multiple x and y columns

Welcome to our Forums Technical Support Support Desk Multiple x and y columns

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #6238
    thopa
    Participant

      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

       

      picture-min

      #6239
      pamela
      Moderator

        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.

        PointsGroups

        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.

        PointsColors

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

         

        #6242
        thopa
        Participant

          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.

           

          Screen Shot 2021-03-31 at 23.28.06-min

          #6243
          thopa
          Participant

            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.

          Viewing 4 posts - 1 through 4 (of 4 total)
          • You must be logged in to reply to this topic.

          Welcome to our Forums Technical Support Support Desk Multiple x and y columns