Ask Your Question
0

Calc: How to stagger selection

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 32 times

Last updated: Mar 07 '17