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

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Deleting a Chart