Data serie down to zero

[Saturn]

How do I avoid that the data serie goes down to zero if there's no value in the data range?
In this case there is a formula in the cell which shows an empty cell.

Please see the attached worksheet.

[zbor]

Use this in E5 and extend down:

Please Login or Register  to view this content.

[Saturn]

Thank you zbor!
This works fine for the chart, but I would prefer to have the cells visually blank and not to show the #N/A error message.
An other thing is that the #N/A-respons affects other cells in my worksheet.
May be a way around is to use conditional formatting but that should be the last solutions.
Any other solutions?

[zbor]

I think you'll need to go with CF.
Other cells that are affected by N/A - there you probably looking IF(E5=""
Then change this in IF(E5=NA()

[zbor]

Or you can create two arrays.
One with blank (for visual) and other with NA (for chart).

They don't need to be in same place so you won't see it.
You can also paint it white (S column in example).

[Saturn]

Thanks. I will work with these two suggestions.

[popipipo]

Or maybe take a look at this:
http://peltiertech.com/Excel/Charts/DynamicCharts.html