Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possible to plot discontiguous cells?
Hi, I posted this yesterday in Miscellaneous, but thought it would be a good idea to ask here, too. I have a column which returns data from other columns based on a set of formulas. The result in each cell can be either a number (to plot in a line chart) or a blank and/or "-" sign like so: 5 - - 3 - - - 8 I would like to be able to chart only the numbers which result in this column. The dashes and numbers will not always position in the same manner as the calculations are altered by user input (therefore I cannot merely return the next number a fixed rows down into another column to form a contiguous range). Also, I have tried using array formulas to form a contiguous range in a neighboring column but the resulting memory overload makes my workbook run very very slowly, so I'd like to avoid this as it's not feasible to work with the workbook afterwards. Does anyone know of a way I could chart only the numbers from such a range? I've read that charts don't graph hidden rows, is there a way to hide a row using a formula's result (say if the cell is going to be "-", then hide it)? Any advice would be welcomed. -Peter -- Peter Bernadyne ------------------------------------------------------------------------ Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017 View this thread: http://www.excelforum.com/showthread...hreadid=540669 |
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-to not plot cells with zero value on graphs | Excel Discussion (Misc queries) | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Plot Wizard -- "Not enough system resources to display completely. | Charts and Charting in Excel |