Numbers: 2D 2-Axis Pseudo Scatter Plot

Based upon this discussion:

2 Y axis with X-axis also being numeric - Apple Community

Question: "Hello, I understand we plot 2 Y axis while keeping X-axis non-numeric. I'm interested in plotting 2 Y-axis (on either side) with X axis being a numeric."

While we all wait for Apple to introduce a 2 Y-axis scatter plot with a linear (variable, not category) X axis, perhaps we can cheat.

The table on the right has one Header Row and one Header Column (as is usual for a Category graph).

Column A is Actual values (Text).

Formula in B2:

XLOOKUP($A2,Raw Data::$A,Raw Data::B,"",0,1)

Fill down and fill right.

That leaves blank Y1 and Y2 values  where X data are missing. Therefore there are gaps (no data points) along the evenly-spaced X axis in the pseudo scatter plot.

Added by SGIII:

I tried it with some "dates" (making sure they were entered as Text).

Thanks SG!

Regards,

Ian.