Graphing only even/odd numbered cells

  • Thread starter Thread starter gantzlia
  • Start date Start date
G

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