Microsoft KB Archive/94718

= Microsoft Knowledge Base =

Excel: ChartWizard Does Not Use Custom Template
Last reviewed: September 12, 1996

Article ID: Q94718

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
In version 4.0 of Microsoft Excel, if you choose any of the chart types in step 2 or step 3 of the ChartWizard, Microsoft Excel will revert to the default chart settings (even if you have specified a custom template).

Note: The default settings for Microsoft Excel charts are stored in the Chart file in the Excel Startup Folder (4) (if you are using a Macintosh computer) or in the CHART.XLT file in the XLSTART directory (if you are using Windows).

Workaround

To force the ChartWizard to use the custom template, select either the >> (fast forward) button or the Next> button when you run steps 2 and 3 of the ChartWizard.

MORE INFORMATION
Steps 2 and 3 of the ChartWizard execute commands that are similar to the commands available on the Gallery menu on the Chart toolbar. These steps are used to define the type of chart. When you edit a chart, if you choose a command from the Gallery menu, the current chart settings will be reset to the default settings. For example, if you turn on chart gridlines and then choose a type of chart from the Gallery menu that does not contain gridlines, the gridlines will be removed from your chart.

This problem does not occur when you select options in steps 4 and 5 of the ChartWizard; these steps add items to the chart and do not change the type of chart.