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