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
TDK_Long
Level III

How to make a plot of scatter with lines and markers like Excel?

Hi folks,

 

I am having a hard time of duplicating an Excel plot of scatter with lines and markers in JMP. The Excel table and plot is shown below as an example:

 

TDK_Long_0-1719603121046.png

 

I know we need to format the data table in JMP, I did the following data table, but still cannot plot the scatter with lines and markers. , could anyone advise how can I do it in JMP? Thanks.

 

TDK_Long_1-1719603222623.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
stan_koprowski
Community Manager Community Manager

Re: How to make a plot of scatter with lines and markers like Excel?

Hi @TDK_Long 
Right-Click on the graph and click customize to change the maker shape.
Graph Builder CustomizeGraph Builder CustomizeGraph Builder Change Marker ShapeGraph Builder Change Marker Shape

 

Right-Click on the axis to add grid lines
Axis Settings Add Grid LinesAxis Settings Add Grid Lines


Graph Builder Line with customized markerGraph Builder Line with customized marker
Does this help?

 

cheers,

Stan

View solution in original post

4 REPLIES 4
stan_koprowski
Community Manager Community Manager

Re: How to make a plot of scatter with lines and markers like Excel?

Hi @TDK_Long 
Right-Click on the graph and click customize to change the maker shape.
Graph Builder CustomizeGraph Builder CustomizeGraph Builder Change Marker ShapeGraph Builder Change Marker Shape

 

Right-Click on the axis to add grid lines
Axis Settings Add Grid LinesAxis Settings Add Grid Lines


Graph Builder Line with customized markerGraph Builder Line with customized marker
Does this help?

 

cheers,

Stan

TDK_Long
Level III

Re: How to make a plot of scatter with lines and markers like Excel?

Hi Stan,

 

I have a problem at the first step. How do you create the two lines? I cannot connect the three points as shown below. Could you use the attached jmp file to see what I am missing? Thank you. 

 

TDK_Long_0-1719608940974.png

 

hogi
Level XII

Re: How to make a plot of scatter with lines and markers like Excel?

Drag Group onto the Overlay dropzone. That's it.
[x on x, y on y]

If you want to connect the lines instead of a smoother, just switch from smoother to "Line":

hogi_0-1719605448562.png

 

by right-clicking on the legend, you can adjust the colors and markers.

and via the red triangle menu, you can specify the legend position to be at the bottom.

 

TDK_Long
Level III

Re: How to make a plot of scatter with lines and markers like Excel?

Hi Hogi,

 

Thanks for the tips. Now I understand it. Much appreciated.