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.
Free Ebook???- 30 Charting Tips For Excel
Just click below for your FREE Book.