Hi,

That option will only apply to cells that are truly empty.

You can either use another column with the variation of the formula
returning "" so the maximum scale value can be determined.
Or perhaps modify your formula to determine the maximum value. The array
formula, commit using CTRL+SHIFT+ENTER, will return the maximum value of the
cells B2:B6 ignoring any that contain #N/A

=MAX(IF(ISNA(B2:B6),"",B2:B6))

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Paul Martin" wrote in message
...
I should also mention that I've seen the posts about setting the Chart
Options to plot empty cells as 'Not plotted' (which has no effect) and
'Interpolated' (which is not enabled), so this seems to be no help.