| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Chart on a different sheet
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Chart on a different sheet
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Chart on a different sheet
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Chart on a different sheet
Your help is much appreciated
"Peo Sjoblom" wrote: 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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Chart on a different sheet
What code would I require if I wanted to start at Col D row 200 and work down
Thanks "Peo Sjoblom" wrote: 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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Chart on a different sheet
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 "pcor" wrote in message ... What code would I require if I wanted to start at Col D row 200 and work down Thanks "Peo Sjoblom" wrote: 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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Chart on a different sheet
That was just great.Thanks- I was looking for the "FIRST"
"Peo Sjoblom" wrote: 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 "pcor" wrote in message ... What code would I require if I wanted to start at Col D row 200 and work down Thanks "Peo Sjoblom" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ???Replicate a sheet but chart still link to original sheet | Charts and Charting in Excel | |||
| Moving Pivot Chart Fields on a chart sheet | Charts and Charting in Excel | |||
| Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
| Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
| How do you center the pie chart on the chart sheet | Charts and Charting in Excel | |||
Linear Mode
