Line chart for every 5th cell in a row
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! |
All times are GMT +1. The time now is 04:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com