Chart
 

How do I tell Excel not to chart a cell? For example, chart area is Cell
C1:C28 there is an HLookup formula which look for a value in a different
sheet. The HLookup formula returns a value #DIV/0! in cell C28, but the
chart stills plot it. I want Cell C28 to be treated as nothing don't plot
it. If I deleted the HLookup formula in C28, Excel will not ploted it.

Chart
 

You could test for the error. Turn your lookup function

=lookup function

into this

=IF(ISERROR(lookup function),NA(),lookup function)

NA() places a different error in the cell, #N/A, which is not plotted in
a line or XY chart. Any line connecting points passes over the gap.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Gap from Target wrote:
How do I tell Excel not to chart a cell? For example, chart area is Cell
C1:C28 there is an HLookup formula which look for a value in a different
sheet. The HLookup formula returns a value #DIV/0! in cell C28, but the
chart stills plot it. I want Cell C28 to be treated as nothing don't plot
it. If I deleted the HLookup formula in C28, Excel will not ploted it.

Chart
 

Change the formula in C28 to something like:
=IF(ISERROR(Hlookupformula),NA(),Hlookupformula)

Charts will "skip over" the NA error.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gap from Target" wrote:

How do I tell Excel not to chart a cell? For example, chart area is Cell
C1:C28 there is an HLookup formula which look for a value in a different
sheet. The HLookup formula returns a value #DIV/0! in cell C28, but the
chart stills plot it. I want Cell C28 to be treated as nothing don't plot
it. If I deleted the HLookup formula in C28, Excel will not ploted it.