Is it possible to plot discontiguous cells?
 

Hi,

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=540456