Graphing only even/odd numbered cells

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

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top