Microsoft Office Tutorials and References
In Depth Information
Chart Wizard – Step 4 of 4
Changing the Default Chart Type
I mention the default chart type several times in this chapter. The default chart type is
the chart that is created if you don’t specify the type. Excel’s default chart type is a
2D clustered column chart with a light-gray plot area, a legend on the right, and
If you don’t like the looks of this chart or if you typically use a different type of chart,
you can easily change the default chart in the following manner:
1. Select the Chart
Chart Type command.
2. Choose the chart type that you want to use as the default chart. This can be
a chart from either the Standard Types tab or the Custom Types tab.
3. Click the button labeled Set As Default Chart Type. You are asked to verify
If you have many charts of the same type to create, changing the default chart format
to the chart type with which you’re working is much more efficient than separately
formatting each chart. Then, you can create all your charts without having to select
the chart type
If you create an embedded chart, Excel centers the chart in the workbook
window and activates the chart. The proportions of the chart correspond to
the proportions of the workbook window.
Figure 1-17: Step 4 of the Chart Wizard asks
you where to put the chart.
Figure 1-18 shows the complete chart. You may or may not be satisfied with the
chart. If not, it’s a simple matter to modify the chart to your liking.