BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Posted by Andrew Gould on 10 November 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Setting the Default Chart Type in Microsoft Excel
The default chart type in Microsoft Excel is a column chart. If you produce pie charts exclusively you'll be annoyed with the process of creating a chart and then having to constantly change the chart type to your preferred type, especially if you use the F11 keyboard shortcut to create your charts. Fortunately, you can change the default chart to any type that you like, including custom charts that you have created!
You can change the default chart type as many times as you like, so don't worry about messing up any Excel settings.
Changing the Default Chart Type in Excel 2003
To start with you need to have created a chart. The quickest way by far to do this is to select some data and then press F11 on the keyboard. Once you've done this:
- From the menu select: Chart -> Chart Type...
- Complete the dialog box as shown below:

3. Choose the category of chart you want.
- On the message box that appears, confirm that you want to change the default chart type by clicking Yes.
- Click OK.
From now on, whenever you create a new chart using the F11 keyboard shortcut you will automatically receive the chart type you have chosen.
Changing the Default Chart Type in Excel 2007 and 2010
To start with you need to have created a chart. The quickest way by far to do this is to select some data and then press F11 on the keyboard. Once you've done this:
- From the Ribbon select: Design -> Change Chart Type
- Complete the dialog box as shown below:

3. Choose the category of chart you want.
- Click OK to finish changing the default chart type.
Our Excel training courses also cover how to create and format charts in Excel, and a great deal more besides!