We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc chart behaves strangely.

asked 2020-10-28 05:12:29 +0200

kiwi_writer gravatar image

updated 2020-10-28 08:41:46 +0200

I have a simple Calc table with Col A being a date and Col B containing related data (simple number). I have made a basic line chart to show how the data changes. When the x-axis gets beyond a certain point (in this case, 122 rows), the chart forces the start point to the date in row 123 and crushes the remaining data aginst the right axis. See file attached. I can't determine what is causing this behavour. C:\fakepath\chart behaviour.ods

edit retag flag offensive close merge delete


Upload your file. (/upfiles/16038583957277471.ods) does not link to any. Try again.

Grantler gravatar imageGrantler ( 2020-10-28 08:23:46 +0200 )edit

Done - sorry!

kiwi_writer gravatar imagekiwi_writer ( 2020-10-28 08:41:44 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-10-28 09:59:56 +0200

Earnest Al gravatar image

updated 2020-10-28 10:01:23 +0200

It looks like a typo, cell A123 is 08/09/2000, it should read 08/09/2020. Might be worth changing formatting to show year. Cheers, Al

edit flag offensive delete link more


@kiwi_writer - are you aware that format of labels and format of the raw data can be set independently? Select your axis and Right click -> Format Axis... -Tab: Numbers and deselect option [x] Source format. Now you can select the format of the data, how they should appear on the chart without changing the format of the raw data.

Opaque gravatar imageOpaque ( 2020-10-28 13:21:23 +0200 )edit

Thanks Al - never occurred to me to check the full date! Opaque - thanks for the pointer on deselcting Source format.

kiwi_writer gravatar imagekiwi_writer ( 2020-10-29 07:15:17 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-28 05:12:29 +0200

Seen: 38 times

Last updated: Oct 28 '20