Hi everyone,

You've all been able to help me a ton in the past and I'm hoping you

can do it now as well.

I have a chart that utilizes dynamic name ranges (OFFSET formulas) and

a dynamic graph that uses those ranges to automatically update the

graph using SERIES. This used to work great until I "tweaked" it.

Here's the problem: I added a new formula to the bottom of a column

with data in it that will add data to this column if another column

gets data added first.

e.g.

Currently Column D has the #28 in it. If the user types 29 in the cell

below it, using an IFstatement, Column F applies the formula in it.

Here is the formula in cells F38:F1000-

=IF(D39="","",$F$8+($A$12*D39))

Now that I have formulas in the "empty" cells of column F, the graph

thinks there is data there and puts placeholder 0s there.

How can I tell my graph to ignore the formulas and only add data if the

range includes numbers only? Thank you, cabybake

## Bookmarks