Ask Your Question

When creating a scatter graph, it keeps changing the values of my x-axis

asked 2020-06-18 22:39:28 +0100

timbob gravatar image

updated 2020-09-21 23:12:13 +0100

Alex Kemp gravatar image

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) C:\fakepath\samplefile.ods

edit retag flag offensive close merge delete


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

Opaque gravatar imageOpaque ( 2020-06-18 22:46:35 +0100 )edit

updated, and here's the system info - Version: (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

timbob gravatar imagetimbob ( 2020-06-18 22:53:28 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-18 22:58:54 +0100

Opaque gravatar image

updated 2020-06-20 14:49:10 +0100


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: C:\fakepath\ScatterChangingValuesModified.ods

Hope that helps.

edit flag offensive delete link more


That worked, thank you!

timbob gravatar imagetimbob ( 2020-06-18 23:38:29 +0100 )edit

If you consider your question answered, it would be nice, if you'd click the check mark (✔) next to the answer. Thanks in advance …

Opaque gravatar imageOpaque ( 2020-06-18 23:43:28 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-18 22:39:28 +0100

Seen: 51 times

Last updated: Jun 20 '20