try this
configure the formual so that blanks are enterd as #N/A


"matsuda" wrote in message
...
i have a chart set up to chart data calculated from a formula, if no data
is
entered into the formula the chart plots that perticlar date as zero. How
do
set it up so nothing is plotted unless a value has been input?