Selecting lots of charts

P

pwermuth

How can I delete a lot of charts? Is there any way to select all
charts and then deselect the few I don't want to delete?

Or is the only option to delete not only the contents but the entire
cells (rows, columns,...) that the charts are based in?

Peter
 
S

ScottO

Assuming that these charts are objects in a worksheet, you could use Select
Special (press F5 and hit the Special button on the lower left), then choose
objects.
This will select all the objects on the sheet charts, shapes, text boxes,
etc..
You can then deselect the ones you want to keep and delete the rest.
Rgds,
ScottO

message |
| How can I delete a lot of charts? Is there any way to select all
| charts and then deselect the few I don't want to delete?
|
| Or is the only option to delete not only the contents but the entire
| cells (rows, columns,...) that the charts are based in?
|
| Peter
|
|
| --
| pwermuth
| ------------------------------------------------------------------------
| pwermuth's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24997
| View this thread: http://www.excelforum.com/showthread.php?threadid=385432
|
 
D

Debra Dalgleish

To select all the objects on the sheet --
Choose Edit>Go To, click Special
Select Objects, click OK

Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:

Choose Tools>Customize
Select the Commands tab
Select the Drawing Category
Drag the 'Select Multiple Objects' tool onto one of your toolbars
Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.
 
J

Jon Peltier

Note that deleting the rows or columns without deleting the chart
objects themselves will leave you with hairline width or height charts,
which are hard to detect afterwards, though they can cause plenty of grief.

You could go to the Immediate Window of the VB Editor, type in the
following line, and press Enter to select all the chart objects:

ActiveSheet.ChartObjects.Select

or if you didn't want to unselect a few first, this line deletes them all:

ActiveSheet.ChartObjects.Delete

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