New user of LibreOffice, using charts produced in Excel over several years. I get monthly spacing on my x-axis, but want weekly spacing. I edit the axis format, and the spacing shows as weekly. Then press OK, and click outside the chart, and it goes back to monthly spacing! I could do this OK in Excel, but dont have that anymore. Help please.
I cannot confirm this. What’s your version of LibO? (Your OS?)
In what way (exactly) did you format the axis?
Were all your charts converted from Excel documents? Did you try it also with a newly created chart?
Charts are very complex, and surely there is no exact mapping of properties accross different applications.
Best upload an example file.
Just my own oberservation - a similiar behavior is seen on diagrams originally created with LibreOffice (and not converted from Excel). I need to close the file (or a do a “save / reload”) to make visible changes in the scaling of axis in almost all cases.
My current config is:
Version: 6.2.2.2
Build-ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU-Threads: 8; BS: Linux 4.12; UI-Render: Standard; VCL: kde5;
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
Calc: threaded
Distrubution: OpenSUSE Leap 15.0 but using LO native (not the version of the distribution)
but I observed this for a long time (meaning “many previous releases”) and somehow got used to the issue and worked around.
Is this problem peculiar to graduating the x-axis in weeks/months? A calendar variable? I have never had the problem described, but my x-axes are always just a pure number (voltage, frequency, time in hours, etc) and not converted from Excel.
I have version 6.1.5.2, running on Windows 10 Home.
I’ve used the dates for x-axis format since about 2009, on Excel, to give me values per week, on several different charts. Would like to be able to continue these graphs in the future. All suggestions welcomed.
Forgot to say, all my spreadsheets and integrated graphs are currently loaded from my Excel backups, have not yet tried creating new ones in LO.
“have not yet tried creating new ones in LO”
As @Lupp suggested, it would be informative to try that. It could help to better define the problem.