Microsoft KB Archive/161348

= XL97: Setting Default and User-Defined Chart Types =

Article ID: 161348

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q161348





SUMMARY
In Microsoft Excel, the original default chart type is a two-dimensional column chart. This article explains how to create a user-defined chart type and how to change the default chart type to a user-defined chart type.



Creating a User-Defined Chart Type
To create a custom chart format, use the following steps:

  In a new worksheet, type the following information:  A1: Apples     B1: 25 A2: Oranges    B2: 15 A3: Peaches    B3: 10 A4: Bananas    B4: 30 A5: Tangerines B5: 15  Select the cell range A1:B5 and press F11.

A new chart sheet that uses the current default chart type is created (The original default type is a two-dimensional column chart). Note that the chart sheet is the active sheet in the workbook. On the Chart menu, click Chart Type. In the Chart Type dialog box, click Line, and then click OK.

The chart type is a line chart. On the Chart menu, click Chart Options. Click the Chart Title box, type My Custom Chart, and then click OK.

"My Custom Chart" appears at the top of the chart. On the Chart menu, click Chart Type.</li> Click the Custom Types tab, and then click User-Defined.</li> Click Add, and then type My Test Format in the Name box.</li> Click OK.</li></ol>

You can select this custom chart format each time you create a new chart.

NOTE: User-defined chart formats are stored in a file called Xlusrgal.xls, which is located in the Program Files\Microsoft Office\Office folder.

Changing the Chart Format to a User-Defined Chart Type
To apply a custom chart format to an existing chart, use the following steps:


 * 1) Reselect the data that you typed in step 1 of the "Creating a User- Defined Chart Format" section, and then press F11.

A new chart sheet is created with the current default chart type. Note that this chart sheet is the active sheet in the workbook.
 * 1) On the Chart menu, click Chart Type.
 * 2) Click the Custom Types tab, and then click User-Defined.
 * 3) In the Chart Type list, click My Test Format, and then click OK.

The chart uses the user-defined chart format.

Changing the Default Chart Type
The following steps assume that you followed steps 1 through 9 in the "Creating a User-Defined Chart Format" section:


 * 1) On the Chart menu, click Chart Type.
 * 2) Click the Custom Types tab, and then click User-Defined.
 * 3) In the Chart Type list, click My Test Format, and then click "Set as default chart." Click Yes in the dialog box that appears.
 * 4) Click OK.

The default chart type is the user-defined chart type.

To verify that the default chart format is changed, use the following steps:


 * 1) Reselect the data that you typed in Step 1 of the "Creating a User- Defined Chart Format" section.
 * 2) Press F11.

The chart format that appears should be the custom format you created.

Resetting the Default Chart Type to the Original Default Type
To reset the default chart type to the original chart type, use the following steps:


 * 1) On the Chart menu, click Chart Type.
 * 2) Click the Custom Types tab, and then click User-Defined.
 * 3) In the Chart Type list, click Default, and then click Delete. Click Yes in the dialog box that appears.
 * 4) Click OK.

<div class="references_section">