Change The Default Chart Type In Excel

Written by Barbara ● in Blog,Excel Charting

When Excel is installed the default chart is a clustered column chart, so if you hit F11 for a quick chart then that is the type of chart that is created.

If you do not often use a clustered column chart that often, then you can change the default type that Excel creates. In Excel 2010 it’s done in a few steps….

 

  • Create a chart as normal.
  • Select Change Chart Type from Design Tab in Chart Tools.
  • Select the type of chart you prefer to be your default type.
  • Click Set As Default Chart button.

…and that is it. Easy. Now when you go to create a super quick chart excel will choose the YOUR chart type specified.

set default chart

 

More Excel Tips

 

 

1. Create dynamic titles in Excel charts

2. Quickie Excel Tip :Change your chart type

3. Make all of your Excel charts the same size

 

Free Ebook???- 30 Charting Tips For Excel

Just click below for your FREE Book.

images-15

 

 

 

 

 

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts

© 2024 Copyright How To Excel At Excel