A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Getting rid of unusable charts?



 
 
Thread Tools Display Modes
  #1  
Old May 3rd, 2006, 09:26 PM posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.worksheet
external usenet poster
 
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?


  #2  
Old May 4th, 2006, 12:30 AM posted to microsoft.public.excel.charting,microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.