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


--
jimsmith888
------------------------------------------------------------------------
jimsmith888's Profile: http://www.excelforum.com/member.php...o&userid=23718
View this thread: http://www.excelforum.com/showthread...hreadid=373951