One way ..
Assuming the data is in Sheet1
In Sheet2:
Put in A1: =OFFSET(Sheet1!$B$17,,COLUMNS($A$1:A1)*5-5,)
Put in A2: =OFFSET(Sheet1!$D$17,,COLUMNS($A$1:A1)*5-5,)
Select A1:A2, fill across say, 3 cols to C2
A1:C1 will return the figures from Sheet1's B17, G17, L17
A2:C2 will return the figures from Sheet1's D17, I17, N17
Now we can plot the graphs on these 2 ranges ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"bluenose" wrote in
message ...
I have no idea how to do this, i cannot select individual cells manually
because there is too much data and i want it to pickup every 5th cell in
the row.
I want one range on the line chart to plot B17, G17, L17..... etc.
Then i want the next range to do D17, I17, N17.....etc
So going up 5 letters of the alphabet at a time. One starting at B one
starting at D
Any ideas?
Cheers
Kev
--
bluenose
------------------------------------------------------------------------
bluenose's Profile:
http://www.excelforum.com/member.php...o&userid=26169
View this thread: http://www.excelforum.com/showthread...hreadid=394875