Graphing only even/odd numbered cells

[gantzlia]

Is it possible to graph only the even (or odd) cells. For example- I have information only in A2, A4, A6, A8 etc. but cells A3, A5, A7, A9 are NULL. Therefore, instead of manually dragging the information from the even numbered cells and forming a continuous column, is it possible to form a graph of jsut the even numbered cells of that column?
Thanks,

[Ed Ferrero]

Hi gantzlia,

If the original data is in a column starting in A2, then enter 2 in B2,
=B2+2 in B3, and copy down.
Then enter =INDIRECT(ADDRESS(B2,1)) in cell C2 and copy down.
Graph column C to show only even cells.

Ed Ferrero
http://www.edferrero.com


>
> Is it possible to graph only the even (or odd) cells. For example- I
> have information only in A2, A4, A6, A8 etc. but cells A3, A5, A7, A9
> are NULL. Therefore, instead of manually dragging the information from
> the even numbered cells and forming a continuous column, is it possible
> to form a graph of jsut the even numbered cells of that column?
> Thanks,
>
>
> --
> gantzlia
> ------------------------------------------------------------------------
> gantzlia's Profile:
> http://www.excelforum.com/member.php...o&userid=30067
> View this thread: http://www.excelforum.com/showthread...hreadid=497484
>

[Tushar Mehta]

An alternative to Ed's idea would be a named formula. Create one with
Insert | Name > Define...

aRng =N(OFFSET(Sheet1!$A$2,(ROW(Sheet1!$1:$10)-1)*2,0,1,1))

Now, plot a chart with aRng as the source. For how, see
Names in Charts
http://www.tushar-
mehta.com/excel/newsgroups/dynamic_charts/names_in_charts.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> Is it possible to graph only the even (or odd) cells. For example- I
> have information only in A2, A4, A6, A8 etc. but cells A3, A5, A7, A9
> are NULL. Therefore, instead of manually dragging the information from
> the even numbered cells and forming a continuous column, is it possible
> to form a graph of jsut the even numbered cells of that column?
> Thanks,
>
>
> --
> gantzlia
> ------------------------------------------------------------------------
> gantzlia's Profile: http://www.excelforum.com/member.php...o&userid=30067
> View this thread: http://www.excelforum.com/showthread...hreadid=497484
>
>