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/
_______


jimsmith888 wrote:
> 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
>
>