Prevent a graph seeing a formula as zero

  • Thread starter Thread starter Roger Drake
  • Start date Start date
R

Roger Drake

I have a series of excel spreadsheets that contain data
and formulae to record production information for each
month of the year.

These spreadsheets are linked to a another that selects
specific data which is used to create a graph. The range
of the graph is Jan - Dec.

On the original spreadsheets I have tried formulae to
return zero:
=if ((calculation) = 0,0,(caluulation0)
Blank
=if((calculation)=0,"",(calculation))
and N/A
=if((calculation)=0,NA(),(calculation))

Regardles of the formula I use the spreadsheet collating
the information for the graph sees the linked cell as
having a value.

When the January information is put in the line graph
works perfectly but all the lines drop to zero for Feb
onwards.

Can anyone suggest how I can get the line to show the
valid Jan data and prevent it from droping to zero i.e.
ignore the fact that Feb is a formula returning zero until
such time as I input the Feb information?

Many thanks

Roger
 
Back
Top