Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fan charts | Charts and Charting in Excel | |||
Column Chart to Line Chart | New Users to Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel | |||
Cell value as chart scale maximum | Charts and Charting in Excel |