Chart on a different sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Your help is much appreciated

Peo Sjoblom said:
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
Click to expand...
 
It should be the same, that's the beauty of using rows as opposed to row.

Of course if you meant that you want to get the first value from Sheet2!D200
then just change it to


=INDEX(Sheet2!$D$200:$D$65535,ROWS($1:1)*7-6)


and copy down


but if you mean that you want to put this formula in D200 then it would be
unchanged


--
Regards,

Peo Sjoblom
 
Back
Top