cancel
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
lala
Level VIII

Can JMP make such diagrams as excel does?

13.64,13.71,13.38,12.9,12.85,12.9,12.89,12.76,12.73,12.74,12.65,12.64,12.92,12.83,12.79,13.08,13.57,14.6,16.3,15.23,15.66,15.35,14.7,14.9,14.78,14.3,14.17,14.23,14.68,14.49,14.24,13.97,13.67,13.34,13.35,13.5,13.28,13.47,13.66,13.82,13.82,13.8,13.67,13.97,14.21,14.4,14.1,14.6,15.2,15.11

2024-04-11_16-53-27.png

Thanks!

4 REPLIES 4

Re: Can JMP make such diagrams as excel does?

Hi Lala, 

 

Are you trying to display a run chart of each row? You can do something similar in the new JMP 18 addition with the addition of improved header graphs - in the example below you can see it's displaying the row values for each column in row order. You can achieve this by right clicking > Chart Type > run chart.

 

Ben_Ingham_0-1712827199090.png

 

“All models are wrong, but some are useful”
lala
Level VIII

Re: Can JMP make such diagrams as excel does?

Thank Ben!

Yes, I want each row to display the graph for that row, so it's compact.

dlehman1
Level V

Re: Can JMP make such diagrams as excel does?

I believe what you are wanting are called sparklines (invented by Edward Tufte).  If your data is in rows as you show, then you will want to transpose it so it is in columns.  While you can get the displays at the top of each column as Ben_Ingham shows, you can also produce these in Graph Builder by dragging each of the desired columns into the Y variable range and choosing the line graph (assuming these are in a time sequence - or if you have a specific time variable, put that in the X variable range if it isn't already sorted by time).

jthi
Super User

Re: Can JMP make such diagrams as excel does?

Not really something I would consider you should do with JMP, but you can do this but not directly from your data format.

 

Start

jthi_0-1712848826361.png

Transpose data

jthi_1-1712848835960.png

Stack

jthi_2-1712848860820.png

Create graph

jthi_3-1712848879493.png

and make it into data table

jthi_4-1712848888606.png

Join this back to your original data by matching rows

jthi_5-1712848919978.png

(you can make the graphs cleaner using JSL)

 

 

 

-Jarmo