Written by Allen Wyatt (last updated December 7, 2019)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
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:
An alternative way to delete a chart sheet is to right-click on the tab for the sheet (this displays a Context menu) and then choose Delete.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9204) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Deleting a Chart.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Want a handy way to make the data ranges for your chart more dynamic? Here are some great ideas you can put to work right ...
Discover MoreWhen you want to change the defaults used for charts, a chart template is the way to go. This tip shows how easy it is to ...
Discover MoreWant the title of your chart to change based upon what is placed in a worksheet cell? It's easy; just add a formula to ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2023 Sharon Parq Associates, Inc.
Comments