Line chart for every 5th cell in a row

[bluenose]

I have no idea how to do this, i cannot select individual cells manuall
because there is too much data and i want it to pickup every 5th cell i
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 on
starting at D

Any ideas?

Cheers
Ke

 

[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 ..

 

[bluenose]

that worked a treat thanks mate!

 

[Max]

You're welcome !