David -

Here's a discussion of several methods:

http://peltiertech.com/Excel/ChartsH...ChartData.html

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

David wrote:

Hi Group,
Is there a way similar to "past special values" that I can keep a chart and
delete the source data?