Combine 2 charts with different with variable X axis

G'day and welcome,

Have you tried putting one of the data as a 'Secondary Axis' ?

Or this might help as well Andy Pope's Floatcluster

Please see image attached
excel1.PNG
It doens't really work (I think). Excel is not properly recognising which graph to plot.

Chart expert Jon Peltier does not like broken axis charts (https://peltiertech.com/broken-y-axis-in-excel-chart/ ). He prefers to use panel charts, and what I see in your "objective" picture is a panel chart -- where the left panel covers the x axis values from 0 to 20 and the right panel covers the x axis values from 120 to 140. A panel chart is pretty easy to create in Excel. See Peltier's tutorial and this tutorial https://peltiertech.com/Excel/Charts...venScales.html In those tutorials, the panels are stacking on top, but you want numeric panels "stacking" side by side. The same technique works for this, once we recognize that, in a scatter chart, the horizontal axis is a numeric value axis just like the vertical y axis in other charts. Here's how I might do this:

1) Add a helper column to the source data to compute the x values that the chart will see. Maybe something like =IF(actual x value>break point, actual x value - break point, actual x value)
2) Create scatter chart using the actual Y values as the Y values and the helper column from 1 as the x values.
3) Build the table for the "dummy" series that will become the displayed X axis. Enter 0, left break point-10, right break point+10, and max display axis value into a column of 4 cells (these will be the axis label values). In the column adjacent, enter a similar formula to step 1 to get the actual x values the chart will see for the axis values. In a third column, enter 0s for the Y values for this dummy series.
4) Add another data series to the scatter chart (I like to use the select data dialog) with the 2nd column from step 3 as the X values and the 3rd column from step 3 as the Y values.
5) Format the second data series from step 4 to have data labels, and tell Excel to use the "value from cells" option for the data labels and use the first column from step 3 as the data labels.
6) Other formats to clean up the chart (format the x axis to be invisible, position data labels, line and marker formats for the dummy axis, etc.)

If I understand what you are trying to do, that's probably how I would do it.