cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
KimF808
KimF808
Level I

How do I get the y-axis to reflect the numbers in my x-axis columns in graph builder?

Created: Apr 1, 2022 02:33 PM  |  Last Modified: Jun 11, 2023 4:23 AM (1558 views)

Hi All,

I am plotting spectral signatures of marine macro-algae. I have 55 columns that I put into the x-axis, but the y-axis does not auto reflect the numbers that are contained in the x-axis columns. My x-axis columns are formatted as continuous numeric fixed decimal (2) in both datasheets. This is what it looks like when I plot it: 

KimF808_0-1648836903419.png

 

I found out how to do this once before so that it works as auto-populating the y-axis with a different datasheet, but similarly spectral signatures that have a distinct data layout, but have now spent about a day trying to figure out the answer and could not find it. This is what it should look like with the values on the y-axis auto-populating to the actual values reflected in my x-axis column. I do not want to transform my data for these graphs and want them to show the actual values in my columns. 

 

KimF808_1-1648837029800.png

 

I am using jmpPro 16.0.0 on with Windows (not a mac). I mostly use the user interface- have not scripted much. 

Appreciate any help someone could provide.

 

0 Kudos
2 REPLIES 2
Mark_Bailey
Staff Mark_Bailey
Staff

Re: How do I get the y-axis to reflect the numbers in my x-axis columns in graph builder?

Apr 2, 2022 07:34 AM (1532 views)  |  Posted in reply to message from KimF808 04-01-2022

I do not have an answer to your question. I have a suggestion in a different direction, though. Please see the Functional Data Explorer. It is designed to help explore and analyze functions such as profiles, curves, and spectra.

0 Kudos
Joseph_Reese
Joseph_Reese
Level IV

Re: How do I get the y-axis to reflect the numbers in my x-axis columns in graph builder?

Apr 2, 2022 07:42 AM (1531 views)  |  Posted in reply to message from KimF808 04-01-2022

Hello, happy to try and provide some input but it would be helpful to have some more details on what your two datasets look like.

 

My first thought is that you would really benefit from stacking your data table as it appears you have each wavelength or organism as a separate column. To do that go to Tables > Stack and put all the wavelength columns in the Stack Columns input window. This will give you a table that has one column for your wavelength and one column for your response value. No scripting required and you still have your original units.

 

If you want to use information from two datasets you likely need to use some type of a table join or virtual join. Again, it is tough to say exactly but hope this is helpful. As Mark mentioned, FDE is a great tool if you have JMP PRO.

0 Kudos