View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Chart on a different sheet

1:1 refers to the first row and returns 1, *7-6 means multiply 1 (what rows
return) by 7 then subtract 6
that part will return 1,8,15 and so on

--
Regards,

Peo Sjoblom


"pcor" wrote in message
...
Thanks for the help. I would apperciate it if you would explain the
folllowing:
I assume ($1:1) refers to A1
what does the " *7-6" do
thanks

"Max" wrote:

In Sheet6,

Place this in any starting cell, say, in B2:
=INDEX(Sheet2!A:A,ROWS($1:1)*7-6)
Copy B2 down as far as required.

B2 returns the same as: =Sheet2!A1
B3 returns the same as: =Sheet2!A8
and so on
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pcor" wrote:
I have numbers on SHEET2 that are all 7 cells apart:
A1
A8
A15
A22
etc
I want to create a chart on sheet 6 so I have copied the coordinate as
such
yo shhet 6
=Sheet2!:a1
=sheet2!a8
etc etc
Is there a way that this could be done jmucg faster and better as my
list is
becoming very long.
Thanks