name a chart?

Is there a way to name a chart so the name will stay with the chart
regardless if the location is changed?

I can name a chart while its location is on a regular worksheet;
however, if I move its location to a new sheet, the name goes away.
Then if I move the same chart back to a regular worksheet, the name is
still gone.

Thanks!

Pablo -

If you name the chart, then move it to another worksheet, it will retain
its name. If you turn it into a chart sheet, the name is gone. The
reason is that you're naming the chart object, not the chart. An
embedded chart needs a chart object, which is the container that is
inserted in the sheet to hold it. A chart sheet needs no container.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Pablo wrote:

Is there a way to name a chart so the name will stay with the chart
regardless if the location is changed?

I can name a chart while its location is on a regular worksheet;
however, if I move its location to a new sheet, the name goes away.
Then if I move the same chart back to a regular worksheet, the name is
still gone.

Thanks!