Set data point interval in a Calc Chart

Hello,

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

etc.

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.

@ROSt53 - 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.

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

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.

@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?

@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?