How to Quickly Change Chart Types

by Joanna on April 26, 2008

In this tutorial, you’ll learn how to quickly switch from one chart type to another.

1.Go to File>Open and open the workbook containing the chart that you want to change.

2.Next, click on the chart area to select it and right click it, and go down to Chart Type. Now you will see the Chart Type pop up window appear, under Chart Type, select another chart and click OK.
chart types1
3.Your chart will automatically change to the new chart that you just selected.
chart types2

Great Job! If one chart type stops working for you, now you know how to quickly change it.

Leave a Comment

Previous post: How to Create Your Own Formatting Style Template for Future Spreadsheets

Next post: How to Combine Two Different Chart Types for Maximum Impact

Sitemap