Use the Data points as the values in the x axis

[AussieWayne1]

I posted this question back in 2020 and ultimately found a workaround thanks to considerable input and guidance from keme.

I have the same problem again that needs solving and I had hoped that Libre would have added this ability NATIVELY in the ensuing years, but it seems that may not have occurred. If it has then someone may be kind enough to point it out as I cannot find a simple intuitive way to do it?

Anyhow my problem is shown by this copy paste from the 2020 post?

Hi guys I have a Calc spreadsheet in which I have created a Line Chart with an x axis showing the passage of time in monthly increments starting from the first data point date ie 3rd of December then the next column was 3rd January, then 3rd February and continuing on in this fashion plus a y axis showing numerical values.
I am trying to insert an Secondary x axis that shows the actual date contained within each of the Data Points across the columns of the chart.
I have been able to insert the secondary x axis BUT it is showing the same dates as the primary x axis when I want it to show the dates relating to the various data points across the chart and not the monthly incremental columns.
Does anyone have any advice how I can achieve this outcome please?

Secondary x-Axis reflecting data point dates

keme I want to thank you so much for taking the time and effort to put together the step by step instructions to solving my problem. I was eventually able to follow them and apply them to my sample file and then also to my actual spreadsheet that this all started from. It took me a while to understand the basis of what I was doing but now I think I understand. It appears that your approach is a ‘workaround’ for a shortcoming in the capability of Libre Calc to simply populate the secondary x axis…

Windows 10 up to date and
Version: 7.6.1.2 (X86_64) / LibreOffice Community