How to create a second Y axes scale?I have 9 parameter and 4 of them have a low values (0 to 40) while the others 5 have values from 21 to 780. I would like to graph all together as seem below, but built a second Y axes for the first 4 parameters.
My data set (table) has the following columns:
ID
Time
Parameter
Data
AnalyticsData TableGraphicsRe: How to create a second Y axes scale?Right click on the y-axis in the Graph Builder report and select Move Right, then select the columns you wish to put on a separate y-axis scale on the right side.
Re: How to create a second Y axes scale?Right click on the Y axis and select "Move Right" and then select which parameter to move. Repeat for each parameter to be moved to a Right Side axis
Re: How to create a second Y axes scale?Thank you!
I am not sure why but the option to move right is not showing on my graph builder (see below). Is there a different way to find it?
Re: How to create a second Y axes scale?I suspect the 9 parameters that you reference in your first entry are actually differentiated by an Overlay, and not as separate columns. The Graph Builder output below, does not allow separate axes. That is because there is only one column referenced on the Y axis. The 2 lines/colors are being generated by the specified Overlay column, Sex.
To be able to specify the left and right axes, in my example I split the Height column into separate columns f
or F Height and M Height, and then drag both columns to the Y axis.
In your case, you just need to split your column into the 9 different parameters
Tables=>Split
Re: How to create a second Y axes scale?Thank you, Jim.
Done!
but now the right Y axis does not shows the smoother lines only the dots (see below). How can I show also the lines or another way to represent the trend?
again thank you so much
