Using a column to pull label values

[charles cruzeParticipant]

I would like to prepare a plot using the parameters in the columns to create the levels.  I have been able to use mask to accomplish the major parts of my needs, but I am still missing a step.

The data  contains the important data columns are as follows:

Subject, Day, ParameterID, Parameter Value, LLQ, HLQ, Parameter Units

Using masks on Subject and ParameterID,  I have made a plot that can select each Subject and each parameter and plot the data, the Hi and Low Control lines, R^2 and regression line.  The Title has the Subject name and Parameter ID; The x title is the Day and the Y  currently has the parameter, but I would also like to include the parameter units.  Those can vary between test sites so it needs to be flexible and part of the units column.  I have thought of concatenating the parameter and units columns, while it is ok for the y title, it is messy for the plot title.

 

Thanks,

Charlie

PS: I have enjoyed the youTube replays of the Webinars and have learned a great deal from those.

 

 

 

 

[dgteamModerator]

Hi Charlie,

We just uploaded an example file to mimic your example (See File > On-line examples).

Here is how we setup the sample data …

Use the variable Text menus to change the data and the label will change on the y-axis.

Here is what the graph shows with Parameter ‘a’ selected:

Here is the file with Parameter = ‘b’ selected:

Please take a look and let us know if this is similar to what you wanted to do and any questions you have.

Thanks for the feedback on the webinars!

 

[charles cruzeParticipant]

Thank your for your help.  I was able to apply this technique to my own data and successfully generated a number of plots.  An example is attached.

[dgteamModerator]

Great – Thanks for letting us know!  Nice looking graph 🙂

 

[Author]

Posts