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