horizontal scale with unequal interval

Hi,

I'd like plot Y against X, and X is not evenly different from each other. For example, my two sets:
Y = [10, 10, 11, 12, 13, 25, 36, 40, 45 ]
X = [1, 2, 3, 4, 5, 10, 15, 20, 25]

When X is in the range [1-5], I care about the details (so 1 to 5).
But beyond that I just want to sample every 5 units (hence 5, 10, 15, 20, 25)

And I want the horizontal scale to reflex that by putting the tick marks proportionally with their values (1, 2, 3,...5, 10,..,25).
I tried the line chart, and the scatter, but seems no option for that.
Please help me out, tks.

You will need to use the xy-scatter chart in order to have a true value axis.

To label the axis as you require will need another data series plotted along the axis and use data labels for relevant data points.