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.

 

 

 

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.