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

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

TDK_Long — Fri, 28 Jun 2024 19:34:36 GMT

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:

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.

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

stan_koprowski — Fri, 28 Jun 2024 20:15:10 GMT

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

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

Graph Builder Line with customized marker
Does this help?

cheers,

Stan

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

hogi — Fri, 28 Jun 2024 20:18:24 GMT

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":

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.

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

TDK_Long — Fri, 28 Jun 2024 21:11:26 GMT

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.

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

TDK_Long — Fri, 28 Jun 2024 21:18:21 GMT

Hi Hogi,

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