Description: I have a spreadsheet with a table of values which correspond to dates and a scatter chart to show them. I duplicated the sheet and set new dates on the new sheet but the scatter chart still shows the dates on the original sheet. I have put a screenshot in my dropbox together with the actual .ods file. Screenshot: https://www.dropbox.com/s/fd52dqg7s42d6l0/LibreOffice%20calc%20foible.jpg?dl=0 ODS file: https://www.dropbox.com/scl/fi/c656q2vllb1i1mqy581aj/Mike-s-BP.ods?dl=0&rlkey=2cnqoebmx82ctu5hb0jva3ecf Note: I will also try to attach these files when the report has been submitted. Steps to Reproduce: 1.Open the given .ods file 2.Double click on the scatter chart 3.Right click the chart and select "Data Ranges" 4.Notice that the X-Values are $'Tables 20230414'.$B$3:$B$16 and that these (highlighted) cells contain the dates from the 1st of April for two weeks whereas the X axis shows the 30th of September through to the 13th of October. Actual Results: X axis dates are shown incorrectly. Expected Results: X axis dates should be shown correctly. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Version: 7.2.7.2 (x64) / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded
Created attachment 186408 [details] The .ods file which demonstrates the foible
Created attachment 186409 [details] Screenshot showing that the X axis has the incorrect values.
The problem is in your min and max values for the x-axis which are far beyond the data values. To solve the problem, choose automatic min and max values in the x-axix config. Closing as NotABug. Best regards. JBF
Thank you Jean-Baptiste, I'm feeling a bit silly that I missed that. Mike.