Copy the entire sheet, including chart and data. Change the data, and the
chart will update.
For the 'No new fonts' error, see this:
http://peltiertech.com/Excel/Charts/FixFonts.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Wanna Learn" wrote in message
...
Hello I'm trying to copy a chart from one worksheet to another. Once I
copy the chart and try to change the source data and I get the message
"No
more fonts may be applied to this workbook" After hitting Ok several
times
the chart options windows appears. If I copy the chart several times excel
crashes.
So how do I copy a chart to another sheet? what I'm I doing wrong