Getting rid of unusable charts?
 

Last year I created an Excel worksheet around neighborhood property
appraisals. The sheet had about a dozen columns. I also created half a
dozen charts using data from different columns.



This year I updated the worksheet, added new columns and deleted a few old
ones. I would like to delete the charts that I created last year and
construct new ones. Unfortunately, the cells referenced by the charts have
been moved or no longer exist. When I click on a chart, I get a message
that . . . "Microsoft Excel has encountered a problem and has to close . .
.". I can't open a chart to delete it. Any suggestions as to how I can
get rid of the string of useless charts OR copy the information on the
worksheet to a new worksheet with no charts?

Getting rid of unusable charts?
 

You could use a bit of code to delete them. With Excel open and the sheet
with broken charts as the active sheet, press ALT+F11 to switch to the VB
Editor. Press CTRL+G to open the Immediate Window. Paste this line into the
window, put the cursor in the line, and press Return:

activesheet.chartobjects.delete

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

"Bubba" wrote in message
...
Last year I created an Excel worksheet around neighborhood property
appraisals. The sheet had about a dozen columns. I also created half a
dozen charts using data from different columns.



This year I updated the worksheet, added new columns and deleted a few old
ones. I would like to delete the charts that I created last year and
construct new ones. Unfortunately, the cells referenced by the charts
have been moved or no longer exist. When I click on a chart, I get a
message that . . . "Microsoft Excel has encountered a problem and has to
close . . .". I can't open a chart to delete it. Any suggestions as to
how I can get rid of the string of useless charts OR copy the information
on the worksheet to a new worksheet with no charts?