Trying to make a dynamic chart to graph every OTHER row of data.

Hi all,

I know how to make a graph that references a name, so that as more columns of data are added to the spreadsheet the name updates and thus so does the graph.

For example, I can create a name like this:

TIMES =OFFSET(Time!$A$5,0,1):OFFSET(Time!$A$5,0,COUNTA(Time!$5:$5)-1)

This will create a name called "TIMES" that creates a series using the second column in row A through the end of however many columns of data there are in row A. In my case, row 1 contains titles and this is why I am using an offset of 1 and -1 on the return for COUNTA - to ignore the first column of data.

If I make a chart, and I create a Legend Entry that references TIMES:

='times.xls'!TIMES

then I get a graph of this range of data, and the graph updates no matter how many columns of data I enter.

The question
I would like to create a name to follow every OTHER column of data. Basically I have columns of data that alternate between cold and warm start-up times. I cannot control this formatting as it is generated by another program.

I would like to create a name that is for the series B5, D5, F5... for as long as there are columns of data. Then I need another name for the series C5, E5, G5... for as long as there are columns of data. My graphics will reference these two series. The idea is that as new pairs of columns are inserted in between columns A and B, the graphs will dynamically update.

Any help would be greatly appreciated.

Thanks,

Steve

So...any ideas?

I tried to define a name and use CNTRL+select to pick every other field of data, but this does not dynamically update and in any case the graph does not plot such a name.

Steve

Can you add another column to your data that has an alternating 0/1 value, and then just filter that column leaving only the desired rows exposed for graphing?

Another possibility would be to use a pivot table/pivot chart which would also allow you to filter items (rows) out based on the data in a column.