Line chart for every 5th cell in a row

[bluenose]

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

[Max]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[bluenose]

that worked a treat thanks mate!

[Max]

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"bluenose" <[email protected]> wrote in
message news:[email protected]...
>
> that worked a treat thanks mate!