create your chart then go toolsoptions chart tab and change plot empty cell
to either not plotted or interpolated
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Roar" wrote:

How do I prevent chart type Area going to zero when cell value is empty og #n/a
--
~roar