Ask Your Question

Set data point interval in a Calc Chart [closed]

asked 2013-04-28 12:57:48 +0200

viko gravatar image

updated 2013-04-28 14:11:32 +0200


Let's say I collect data at random intervals - sometimes daily, sometimes every 2-3-4, etc. days. I want the chart to display data at 7 days intervals - i.e. I don't want to see ANY data points on the chart except for the 7 days ones.

1.4.2013 - 7

8.4.2013 - 7

9.4.2013 - 1

14.4.2013 - 5

16.4.2013 - 2


In this case I need the chart to have 3 data points only - 1,8,15 of April and show the value of 7 for each one - so it would essentially be a straight line with only 3 data points.

I have no idea how to accomplish this, if it's at all possible. I tried everything I could find, I searched, I read - but I still get the 9,14,16 of April as data points on the chart, which really screws the whole purpose of a timeline for me.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-30 21:41:26.134737



@ROSt52 - it only contains the dates that have values/data for them. @mariosv - the problem with hiding cells is that it will not properly reflect the data. Maybe I should create another column that would calculate the weekly averages based on the data in the previous column.

viko gravatar imageviko ( 2013-04-28 18:25:23 +0200 )edit

@ROSt52 - it only contains the dates that have values/data for them.

viko gravatar imageviko ( 2013-04-28 18:25:27 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-04-29 05:55:02 +0200

ROSt52 gravatar image

updated 2013-04-29 12:56:51 +0200

@mariosv - When using a filter, do you need every day listed to filter the 1,8, 15.... days?

@viko - what are the data you are measuring and how do you deal with data taken more or less at random number of times a week?

edit flag offensive delete link more

answered 2013-04-28 16:29:21 +0200

ROSt52 gravatar image

@viko - should the advice from @mariosv not work it is necessary to understand your date column better. Eg. does your date column contain every day or only the days at which you data?

edit flag offensive delete link more

answered 2013-04-28 16:23:21 +0200

m.a.riosv gravatar image

Hi viko,
I think the easy way to get it, is to set a filter for data, hidden the unwanted values.
The options for Data series have one to do not show the hidden values in the serie.

edit flag offensive delete link more

Question Tools


Asked: 2013-04-28 12:57:48 +0200

Seen: 785 times

Last updated: Apr 29 '13