topic Can JMP make such diagrams as excel does? in Discussions

Can JMP make such diagrams as excel does?

lala — Thu, 11 Apr 2024 08:57:21 GMT

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

Thanks!

Re: Can JMP make such diagrams as excel does?

Ben_BarrIngh — Thu, 11 Apr 2024 09:21:53 GMT

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.

Re: Can JMP make such diagrams as excel does?

lala — Thu, 11 Apr 2024 09:42:23 GMT

Thank Ben!

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

Re: Can JMP make such diagrams as excel does?

dlehman1 — Thu, 11 Apr 2024 10:39:20 GMT

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).

Re: Can JMP make such diagrams as excel does?

jthi — Thu, 11 Apr 2024 15:23:10 GMT

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

Start

Transpose data

Stack

Create graph

and make it into data table

Join this back to your original data by matching rows

(you can make the graphs cleaner using JSL)