topic Re: Multiple Y axis in a chart. in Discussions

Multiple Y axis in a chart. (Multiple Y axis scales)

Steve_Kim — Wed, 19 Oct 2016 03:24:34 GMT

Good Morning~ : )

I need your help. I'd like to draw an overlay plot with multiple Y axis as below. (It is commonly used in bioprocess.)

(I'm currently use JMP 12.2.)

- Is there a way to draw like this way? (I can add right Y axis, but I need more.)

- JMP script is also okay for me.

- Hope multiple Y axis drawing feature is supported in JMP 13Graph builder.

Re: Multiple Y axis in a chart.

txnelson — Thu, 21 Jul 2016 11:33:22 GMT

I can imagine how this can be done in JMP, but it would take a fairly complex script.

Roughly, this is what would have to be done:

1. A separate Graph Builder would have to be run for all but one of the columns

2. Each of the columns would have to be transformed to where the new values fit within the min and max range of the one column not charted in the above step.

3. The columns would have to be stacked.

4. A Chart Builder platform needs to be run on the stacked data, with the overlay set to the label column from the stacked data table

5. The Y axis label, and the Y Axis Box() from each of the individually run Graph Builders would have to be prepended to the last Graph Builder chart.

6. Delete the individual Graph Builder chart outputs.

Getting all of this to fit together properly would be doable. Lots of gotchas would have to be worked around, but it could be done.

Re: Multiple Y axis in a chart.

howard_zolla — Thu, 21 Jul 2016 16:12:14 GMT

JMP is wonderful for statistics and I use it every day. However, for complex graphs and customization, especially for publications, there are other programs which do a better job. My favorite is Igor Pro (www.wavemetrics.com).

Re: Multiple Y axis in a chart.

Steve_Kim — Fri, 22 Jul 2016 08:06:55 GMT

Yes, I got your point. Thank you for your answer. I will use graph builder overlay plot by adjusting Y-axis scale. ( I can comment units on the legend) : )

I knew PI or SIMCA software supports this customized overlay feature, but hope JMP 13 or later version support it. haha Thank you.

Re: Multiple Y axis in a chart.

Steve_Kim — Fri, 22 Jul 2016 08:07:40 GMT

Thank you for your suggestion. : )

Re: Multiple Y axis in a chart.

Phil_Brown — Wed, 19 Oct 2016 03:25:51 GMT

<img alt="GBMatrix.png" class="image-1 jive-image" src="https://community.jmp.com/servlet/JiveServlet/downloadImage/12040//servlet/JiveServlet/downloadImage/12040/GBMatrix.png" style="height: 498px; width: 620px;" data-mce-src="/servlet/JiveServlet/downloadImage/12040//servlet/JiveServlet/downloadImage/12040/GBMatrix.png" data-mce-style="height: 498px; width: 620px;">JamesKim,

Another alternative is to use Graph Builder's GROUP Y feature. As txnelson stated, you'll have to stack the data.

Re: Multiple Y axis in a chart.

mpb — Fri, 15 Jun 2018 12:48:42 GMT

Try this script on your table:

Overlay Plot(
    X( :Time ),
    Y( :AAA, :BBB, :CCC, :DDD, :EEE, :FFF, :GGG, :HHH ),
    Overlay( 0 ),
    Connect Points( 1 ),
    Show Points( 0 )
);

You can also do it interactively using Overlay Plot.

Hmmm... I see that you are really after the lower plot in your original post with multiple axes shown to the left and the plots directly overlaid as others have addressed.

Re: Multiple Y axis in a chart. (Multiple Y axis scales)

Peter_Bartell — Mon, 25 Jul 2016 20:53:32 GMT

JamesKim: Maybe I can offer an alternative idea for you? Rather than have multiple y axes as you show above, taking up 1/2 of your visual space, with a spaghetti chart of lines to the right, why not this idea?

Make an index value for each time series where the first observation in time = 100. Then each value is (observation at time t)/(observation at time 1) x 100. This way you can have one y axis, scaled according to the lowest and highest index values. The added interpretational value is that the slopes of the lines will now all be on an even footing and if varying slope is important on a relative % scale, this will add that level of insight. Then you can have a legend to help identify which variable is which by color scheme.

We would show this index style graph all the time when % change was what was most important for variables over time...not the absolute values. Much cleaner graph.

Re: Multiple Y axis in a chart. (Multiple Y axis scales)

Sush — Thu, 16 Mar 2017 21:07:50 GMT

I need to make a 3D graph (with 3 axes) something similar to this below. I have JMP Pro version 12. Is it possible to make a graph like this with JMP?

If yes, can somebody please guide me through the process.

Thanks,

Re: Multiple Y axis in a chart. (Multiple Y axis scales)

Byron_JMP — Sat, 24 Feb 2018 22:30:24 GMT

This is my favorite graph not in JMP, so I took a stab at scripting an automated approach to making the graph.

Byron Wingerd Blog/Multiple-Y-Axis-Graphs

Re: Multiple Y axis in a chart.

Byron_JMP — Sat, 24 Feb 2018 16:17:55 GMT

I totally agree, lots and lots of gotchas in this process, but maybe its possible.

Re: Multiple Y axis in a chart.

Byron_JMP — Thu, 08 Mar 2018 23:06:48 GMT

here's a script to do it

https://community.jmp.com/t5/Byron-Wingerd-s-Blog/Multiple-Y-Axis-Graphs/ba-p/52000

Re: Multiple Y axis in a chart. (Multiple Y axis scales)

AFA — Thu, 15 Mar 2018 12:51:48 GMT

Peter, I agree that it may not be the most attractive graph in its current state. But I work in the same field as James, and frequently it's important to see both the absolute values and the timecourse behavior of multiple (5-6) variables. At the moment, it's difficult to display this type of data in JMP. It would be convenient if multiple Y-axis support and scaling were added in a future JMP version.

One way to address some of the aesthetics of this graph would be to move the y-axis labels to the top or bottom, so that the multiple axis labels could be compressed into a smaller space.