Ask Your Question
0

Calc: How to stagger selection [closed]

asked 2017-03-03 05:08:18 +0200

marty0750 gravatar image

There are 600 entries representing time. Eg

12:00

12:01

12:02

12:03

12:04

12:05

12:06

12:07

12:08

etc...

I want to only select every fifth cell only eg every 5 minutes to make graph. That is, I want to reduce the number of points plotted to 120 over the range. Eg

12:00

12:05

12:10

12:15 etc

Marty

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 2020-09-27 00:00:56.763744

1 Answer

Sort by » oldest newest most voted
1

answered 2017-03-07 19:12:21 +0200

erAck gravatar image

Unfortunately not, but there is a workaround. Create an additional column with repeating values of 1,0,0,0,0,1,0,0,0,0,...; you can do so by entering values into the first 5 cells, select those and copy them to the clipboard, select the target range to be filled, and paste. Then add a column header and on that add an AutoFilter from which you select only the 1 value. Then rows containing 0 in that column are hidden and not displayed in the Chart, unless activated (click data graph to select all points, right click for context menu, Format Data Series, Options, Include values from hidden cells).

edit flag offensive delete link more

Comments

A control column could have a formula like =MOD(MINUTE(A1);5)=0

Mike Kaganski gravatar imageMike Kaganski ( 2019-11-15 06:10:59 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2017-03-03 05:08:18 +0200

Seen: 50 times

Last updated: Mar 07 '17