Ask Your Question
1

Libreoffice Calc Charts: altering data Series range value

asked 2015-09-25 19:50:24 +0200

Mr.Sweet gravatar image

updated 2015-10-05 04:23:57 +0200

Alex Kemp gravatar image

Linux Ubuntu 14.04 Version: 4.2.8.2(Libreoffice-calc 1:4.2.8-0ubuntu2)

I have a problem altering data series range value. I have marked the full table as Data Range. Using Line Chart - having two data series (Line 1 and Line 2). X-axis is just time, Y-axis - are values for Line 1 and Line 2. Now as the data is rather enormous I can´t plot out change for every 100 year. So I need to trim it down to make it more readable. But I still need to image the time period of 100 years. My vision would be to set Line 1 and Line 2 Data values on X per every 5 years: 20 values for each. But when I try to use CTRL or Shift to pick for Line 1 and Line 2 X-axis values I can pick only range not single values like 1, 5,15, 20th value on the list. I remember having done this years ago, but somehow no shift, nor CTRL nor both let me pick that way anymore? I know the semicolon trick, but this is as well time consuming, regarding if data tends to grow.

I can get my work done by altering the table and deleting the values in between, but for future I would hope to get this done faster? Can anyone point out what am I missing, doing wrong? As I do not thing the problem is slightly older version here?

edit retag flag offensive close merge delete

Comments

Don't you think you should supply a relevant example? I will see for your "karma" growing high enough.
Please explain very clearly how -and for what reason- you "...marked the full table as Data Range". You surely didn't define it as the data range of the chart?
Please make clear if you actually do not expect the "time axis" to be a coordinate axis in the technical sense. Only x-y ("scatter") charts have a scale in that sense. A line chart only can show the contents of a label range "as x".

Lupp gravatar imageLupp ( 2015-12-24 20:25:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2015-12-23 22:22:16 +0200

updated 2015-12-24 12:37:22 +0200

Alex Kemp gravatar image

(not an answer)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-09-25 19:46:58 +0200

Seen: 273 times

Last updated: Dec 24 '15