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