I was about to suggest making a copy of the chart (add a copy of the series to the
chart), with the data dumped into a new blank sheet. Then delete rows as needed. But
Tushar's suggestion to hide the undesired rows seems best.

The trick with two series on the chart, one for all data and one for data to
include, is that you can see both series. Click on a point in the "include" series
to exclude it, or click on a point in the "exclude" ("all data") series to include it.

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

Tushar Mehta wrote:

As I was walking away from my desk after the 2nd rambling post, I
thought of something similar which would still protect the data -- just
hide that row (and, of course, set the appropriate option to only plot
visible cells).

Made me feel kinda stupid for making a mountain out of a molehill.