Microsoft KB Archive/68634

{| = Changing the Preferred Chart Type for Embedding in Excel =
 * width="100%"|

Last reviewed: November 7, 1994

Article ID: Q68634 The information in this article applies to:
 * Microsoft Excel for Windows, versions 3.0, 4.0

SUMMARY
The preferred chart type is the default format Microsoft Excel uses when making a chart. When embedding charts in an Excel spreadsheet, Microsoft Excel uses the preferred chart type. Therefore, you cannot use a chart template directly for embedding charts on a worksheet. To embed a chart on a worksheet based on a template, you can change the preferred chart type to that of the template.

MORE INFORMATION
To change the preferred chart type to that of the template, do the following:

 Open a worksheet containing the data you want to chart. Select a blank cell on the worksheet. From the File menu, choose New. Select the chart template from the New dialog box. This creates a blank chart containing all of the template's formatting. Choose OK.  From the Gallery menu, choose Set Preferred. This will set the preferred chart type to be the same as the chart template that you opened. Now you will be able to embed a chart based on an existing template.  Close the blank chart. Select the worksheet data you want to chart.</li> Click the chart tool from the tool bar.</li> Drag the crosshair pointer across the worksheet to create the chart. A chart will appear that contains all the formatting you saved in the chart template.</li></ol>