Ask Your Question
1

Strange y-axis scale in a chart [closed]

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

Luigi gravatar image

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

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: 4.1.3.2 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
1

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

carnendil gravatar image

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

  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

Comments

1

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 +0200 )edit
0

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

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

Comments

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 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 548 times

Last updated: Jan 08 '14