Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |