How to remove blank inputs on X axis when using graph builder?

[#1]

When using the Graph Builder, I am adding to the "data result" to the Y-axis, the "serial number" to the X-axis and then I am grouping X by Part Number.

Basically, I want to compare the results of two different parts, with the data organized by Serial Number.

However, as you can see on the photo, I cannot get JMP to stop display blank data.  Basically, it has the Serial Numbers from the other part number as part of the label on the X-axis.  You can see that PN 789101 SN 190A123156 shows on the X axis on the PN 123456 as blank, and visa-versa for the other part number.

Basically, on the "123456" side of the graph I only want data from PN 123456 to show, and visa versa.  How can I do this?

Software: JMP 18.0.0

[#2]

You will need to split the data by Part Number into 2 separate columns and then add the 2 part numbers on the X axis, side by side.

Then add your Y column.  In my example below, I also added in a reference line after the highest level of the first X axis column.

Using the Big Class data table, with all of the 12 year old females removed, I split by the Sex column.

Here is the graph I created on the split data

Note that the X axis for the females does not have a 12 year old category

[#3]

Starting from this

If you don't mind on missing out of the X-group you can also add both columns to X-axis

You can also use Page and not link X-axis and then move X-axis to "hide" those missing values

There is also a wish list item for this Graph Builder: Option to hide categories with no data 

[#4]

One of the most wanted features - and still missing in JMP.

There is a wish from 2022 which already collected 25 (!!) Kudos:
🙏 X group: restrict the values on the axis to the respective group .

The workaround via stacked labels on the X Axis is - indeed - a workaround ; but far from optimal.
along the idea of Plenary: All Graphs Are Wrong, but Some Are Useful   (@XanGregg ), it's amazing how much a graph can help the viewer understand the message if it separates the Variants (X Group) from some subcategories (on the X axis).