Ask Your Question

Strange y-axis scale in a chart [closed]

asked 2013-11-19 17:49:54 +0100

Luigi gravatar image

updated 2016-02-18 13:33:24 +0100

Alex Kemp gravatar image

Hi. I'm doing some charts and I got a really strange one, with the left axis in which the 0 point has been substituted by esponential notation

The data is given by the orange columns on the right

image description

Thank you in advance!

The version of Calc is: Version: The OS is: Linux Mint 13

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 13:33:33.804601

2 Answers

Sort by » oldest newest most voted

answered 2013-11-19 21:26:05 +0100

carnendil gravatar image

updated 2013-11-19 22:10:33 +0100

  1. Double-click in your image, and then right-click over the Y-axis (the label "Y-axis" should be visible).

    Select Y-axis

  2. Select "Axis format" from the contextual menu.

  3. Go to the "Numbers" tab and de-select (un-check) the option "Format of origin".
  4. Now you can adjust the value of "Decimals" (e.g. to "2") under the "Options" section. Click "OK".

    Adjust decimals to be shown in graphics

    Click to open a full-resolution version of the image.

Now, as to why the Y axis shows this (very small) number when it should be simply zero, I don't know. The axis properties are automatically set so the X-axis should be placed at zero, but the graph somehow shows something else.

This is surely a bug, now it is a matter of finding out whether it has been reported already. If not, please file a bug.

Either way, please post a link to any bugs found or filed in a comment below using the format "fdo#123456".

edit flag offensive delete link more



The problem seems very similar to bug fdo#55960. While the bug description deals with Fill Series in cells I would be unsurprised if the two problems are related.

oweng gravatar imageoweng ( 2013-11-21 07:25:06 +0100 )edit

answered 2013-11-19 19:07:12 +0100

Pedro gravatar image

Can you please provide a link to the file? Which LibreOffice version are you using? Under which OS?

edit flag offensive delete link more


I've added version and OS. I can't upload files because my karma is too low.

Luigi gravatar imageLuigi ( 2013-11-19 19:29:21 +0100 )edit

Question Tools

1 follower


Asked: 2013-11-19 17:49:54 +0100

Seen: 774 times

Last updated: Jan 08 '14