Missing Data Options

[jimsmith888]

I am trying to use Tools - Options - Chart. I want to use the "not
Plotted" option. When I click on it my chart does not change. This
happens after I've selected the chart and then trying to make these
changes.

What am I doing wrong?

I want to create a chart that ignores missing data, and gives me a
trend line based on the data I have.

I've had my nose in my Excel "bible" but can't find the answer.

I greatly appreciate any tips.

Jim

 

[Jon Peltier]

Jim -

If you have a formula in the cell that returns "", that is not missing
data, that is a very short text string, and Excel treats it as zero. If
you replace "" with NA(), you get an ugly #N/A error in the worksheet,
but most chart types ignore it.

Use conditional formatting to hide the error in the sheet:
http://contextures.com/xlCondFormat03.html#Errors

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______