Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Chart Properties for Multiple Chart Shts using a Worksheet | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) |