Getting rid of unusable charts?

[Bubba]

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?

[Jon Peltier]

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" <bubba@houston.rr.nospam.com> wrote in message
news:Ql86g.189$Qq.83@tornado.texas.rr.com...
> 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?
>
>