Blank Cells Plotting as Zeros

Originally Posted by ChristiaanV

Hi,

I am using Excel 2000 to create an interactive chart (one that allows the user to define the starting and ending points and which series are plotted) but I have a number of blank cells in my source data that are plotting as zeros. The blank cells are truly blank: I pasted values for the source data, there are no formulas.

I checked the chart options (Tools-->Options-->Chart) and "Plot Empty Cells as: Not Plotted (Leave Gaps)" is already selected.

As a test, I plotted a series that I manually selected from the source data - I left out the interactive stuff; same result. I have another file with a similar chart--though without the user-definable start and end points--and blank values are treated correctly.

I would appreaciate any help.

Thanks,
Christiaan

Hi,

I think it's a definition of 'empty' instead of using blank as "", if you use #N/A it should leave the point unplotted. (a formula in a cell means the cell fails the 'empty' test)

hth
---

Originally Posted by ChristiaanV

Yep. Typing #N/A in the blank cells did the trick.

Why an empty cell isn't treated as "blank" makes no sense to me, but ok...

Thanks for the help!

Christiaan

Good to see it worked for you, and thanks for your response.
---