You are here: Home / Blog / Change The Default Chart Type In Excel

Change The Default Chart Type In Excel

by

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