View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Use NA() in your formulas. So something like,

=IF(A1="",NA(),A1)

Cheers
Andy

Lee IT wrote:
Using Excel 2003, I have a workbook with a master worksheet and an associated
line chart, also several derivative worksheets with associated individual
line charts. The other worksheets are all linked to their respective columns
on the master sheet so that as the master is periodically updated, the others
update automatically.
The problem is that currently empty cells on the master sheet are displayed
as zero's on the linked worksheets and subsequently plotted on their
individual respective charts. The zero's can be removed from both the linked
worksheets and their respective charts, but the empty plots remain.
The charts contain negative and positive values, so where the chart should
stop (no entry), as does the master chart, it in fact returns to zero
throughout the rest of the chart. Zero IS a valid entry IF it has been
entered on the master sheet.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info