Written by Allen Wyatt (last updated March 18, 2025)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
Excel makes changing chart types of an existing chart a breeze. You can change chart types by following these steps:
Figure 1. The Change Chart Type dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9747) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Changing Chart Types.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Want 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 MoreWhen creating a chart, your axis labels may be wider than desired. One way to deal with them is to change the angle at ...
Discover MoreWhen sending a chart to someone else, it can be frustrating for the other person to open the workbook and see errors ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2025-03-18 06:31:19
jamies
And -
from experience -
Sometimes the chart (window display) needs to have the zoom level changed to get Excel to refresh the displayed chart representation, mode, layout, colour options etc.,
such as up (maybe)10%, wait for the redisplay, then you can go back to the original setting !
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 © 2025 Sharon Parq Associates, Inc.
Comments