TEST.ods the blue line of the chart is wrong. On the same date (ascisse) sort the data (column G) in reverse !!! View the blue line in the shape of ‘z’ in more points
Thanks for your help.
The line is not wrong. Your data area is sorted by date descending, but the X-axis is displaying values ascending, so you need only to reverse the X-axis.
Double click the chart, go to Format → Axis → X Axis…, tab Scale, check Reverse direction.
Update: seeing now that your dates aren’t unique and may have several values associated for one date, you may want to not let the X-axis detect type automatically but in the Scale tab select Text instead, and not check Reverse direction, so the original order is preserved and data for one date isn’t lumped together on one date but displayed as individual data points.
I thank you for the quick and precise response. Now everything is fine!
Many greetings from Italy!
Glad to help. Then please mark the answer as correct by clicking the check mark icon. Thanks.