Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
gantzlia
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
Ed Ferrero
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
how do you "select locked cells" w/o "select unlocked cells"? princejohnpaulfin Excel Discussion (Misc queries) 3 July 16th 05 03:53 AM
Counting only active cells Sac73 Excel Discussion (Misc queries) 16 April 4th 05 05:49 AM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 16th 05 12:14 AM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 01:57 PM


All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"