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

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

that worked a treat thanks mate!


--
bluenose
------------------------------------------------------------------------
bluenose's Profile: http://www.excelforum.com/member.php...o&userid=26169
View this thread: http://www.excelforum.com/showthread...hreadid=394875

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"bluenose" wrote in
message ...

that worked a treat thanks mate!