XL98: Setting Default and User-Defined Chart Types

Last reviewed: February 2, 1998
Article ID: Q178864
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

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.

MORE INFORMATION

Creating a User-Defined Chart Type

To create a custom chart format, follow these steps:

  1. 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
    
    

  2. 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.

  3. On the Chart menu, click Chart Type.

  4. In the Chart Type dialog box, click Line, and then click OK.

    The chart type is a line chart.

  5. On the Chart menu, click Chart Options. Click the Chart Title box, type "My Custom Chart" (without the quotation marks), and then click OK.

    "My Custom Chart" appears at the top of the chart.

  6. On the Chart menu, click Chart Type.

  7. Click the Custom Types tab, and then click User-Defined.

  8. Click Add, and then type "My Test Format" (without the quotation marks) in the Name box.

  9. Click OK.

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

NOTE: User-defined chart formats are stored in a file called Excel Chart User Gallery, which is located in the System Folder:Preferences folder.

Changing the Chart Format to a User-Defined Chart Type

To apply a custom chart format to an existing chart, follow these 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.

  2. On the Chart menu, click Chart Type.

  3. Click the Custom Types tab, and then click User-Defined.

  4. 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, follow these 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, follow these 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.

REFERENCES

For more information about Chart Autoformats, click the Index tab in Microsoft Excel Help, type the following text

   chart creation, templates

and then double-click the selected text to go to the "Save a custom chart type to apply to other charts" topic.


Additional query words: XL98 wizard
Keywords : xlchart xltemp kbualink97
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.