If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
automatically generating charts | Heather Vernon | General Discussion | 0 | February 28th, 2006 10:39 PM |
Excel Charts Linked to Spreadsheets | Rich | Charts and Charting | 1 | July 4th, 2005 04:36 PM |
Distribute dynamically charts with linked data as stand-alone charts | Richard | Charts and Charting | 2 | March 31st, 2004 05:16 PM |
charts inadvertly resized | Hammer_757 | Charts and Charting | 0 | March 24th, 2004 03:16 AM |
Creating a large number of charts automatically (repost) | Francine Kubaka | Charts and Charting | 0 | September 21st, 2003 09:16 PM |