I do not know why, but it’s changing values of my x-axis in a graph and I can’t find where to change to scale to actually be what I originally input. Nothing in formatting of the x-axis helps this. Please help! (upated with file) samplefile.ods
Please upload a sample file and describe how you want it to have. Use edit to add information and the paper clip symbol to upload (requesting this, because on XY(Scatter) charts dialog to format x-axis provides the functionality in tab Scale (just disable [x] Automatic), hence it is unclear, what might be special in your situation)
And if you are at it, please also provide your system information as per Help -> About LibreOffice
updated, and here’s the system info - Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: GL; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: CL
Hello,
the answer is simple - you got no data for the x-axis. The Data Range in your sample file is set to $Sheet1.$C$2:$C$7, hence chart just labels the 5 numbers by 1,2,3,4,5.
Change the Data Range to $Sheet1.$B$2:$C$7
See sample file: ScatterChangingValuesModified.ods
Hope that helps.
That worked, thank you!
If you consider your question answered, it would be nice, if you’d click the check mark (
) next to the answer. Thanks in advance …