cheers gang.
all the solutions seem to revolve around adding helper columns (either
the alternating even/odd indicator or to hold the extracted values).

i was hoping for something i could feed as series definitions to the
chart wizard w/o disturbing the original spreadsheet.
a range with parameters <begin <end <row_step <col_step
would be ideal.
anybody see the excel suggestion box anywhere? ;-)

thanks again.
hwn


" wrote:

given two sets of numbers which have been interleaved/alternated in (e.g) a
column, how can i specify a range that returns every other cell?
thanks.