View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.worksheet
Bubba
 
Posts: n/a
Default 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?