charting blank cells

H

Henrik

Hi,

I have the following issue:

I use a lookup formula that searches for a value in a large dataset
depending on a number of conditions. Sometimes there is no value in the
dataset that satisfies the specified conditions and I want the my formula to
leave the cell blank. The formula below is a simplified version of the
formula that I use:

{=IF(ISERROR(lookup_formula)),"",(lookup_formula))}

Here is my problem: When I chart the data I pull from the larger dataset,
the blank ("") values show up as zeros (0) in my chart. I would like the
chart simply to treat those values as blanks rather than zero. Does anyone
know how to solve this problem? Your help is greatly apprciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

charting blank cells.... 0
How do you get excel to return blank? 0
Drop down list control value in vba 2
Blank instead of "" 5
Problem with Charting Null Values 7
Charting blanks as spaces 1
Excel 2007 charts: want to avoid zero values 1
Chart displaying "blank" cells? 14

Top