hi everyone

another question concerning my line chart:
i have a series which reach from A4 to A20, the first
and the last cells are empty, excel makes en empty
space in the Chart, this would be the perfect solution,
but I changed the Cells to contain a formula, now
excel interprets the cell as 0 which gives me an ugly
line at the beginning and the end of the chart.

i found this (foreign) forum-entry which talks about this issue:
http://experts.about.com/q/Excel-105...pty-values.htm

now, my problem goes further: i have some MAX and MIN calculations
on these cells, with the #N/A the MIN and the MAX statements are producing
only #N/A!

Is there some workaround? or some solution?
Or do i have to calculate the MIN and the MAX statement with a diffrent row?

Cheers and thanks for your Time

Carlo