Deleting a Chart

Summary: At some point you might want to delete a chart you previously created. How you go about the deletion depends on whether the chart was created as an embedded object or as a sheet. This tip explains how to remove both types of charts from a workbook. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel allows you to create all sorts of charts based on the data in a worksheet table. These charts can either be on their own sheets or they can be embedded within a regular worksheet. At some point you may have a need to delete a chart. To delete an embedded chart, all you need to do is select it (so that handles appear around the perimeter of the chart object) and then press the Delete key. If you need to delete a chart sheet, you do so in the same manner as when you delete a regular worksheet:

Display the chart sheet.
Choose Delete Sheet from the Edit menu or, if you are using Excel 2007, display the Home tab of the ribbon and then choose the Delete down-arrow (in the Cells group) and finally Delete Sheet. Excel asks if you are sure you want to delete the sheet.
Click on OK. The chart sheet is deleted.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2523) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.

Check out ExcelTips: The Macros today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Deleting a Chart