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