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