Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Selecting lots of charts
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...o&userid=24997 View this thread: http://www.excelforum.com/showthread...hreadid=385432 |
#2
|
|||
|
|||
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 "pwermuth" wrote in 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...o&userid=24997 | View this thread: http://www.excelforum.com/showthread...hreadid=385432 | |
#3
|
|||
|
|||
To select all the objects on the sheet --
Choose EditGo 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 ToolsCustomize 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. pwermuth wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
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/ _______ pwermuth wrote: 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 |
#5
|
|||
|
|||
Thank you. This worked perfectly. Never knew about GoTo Special -- pwermuth ------------------------------------------------------------------------ pwermuth's Profile: http://www.excelforum.com/member.php...o&userid=24997 View this thread: http://www.excelforum.com/showthread...hreadid=385432 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts won't update | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Urgent help! how to automatically resize all the charts? | Excel Worksheet Functions | |||
Can't create dynamic charts | Charts and Charting in Excel |