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
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).
A control column could have a formula like =MOD(MINUTE(A1);5)=0