Graphing only even/odd numbered cells
 

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

Graphing only even/odd numbered cells
 

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

Graphing only even/odd numbered cells
 

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 ,
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