Microsoft KB Archive/142124

= How to Create a User-Defined Chart Format =

Article ID: 142124

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q142124





SUMMARY
In Microsoft Excel, you can produce charts with a consistent look by creating a user-defined chart format. This article contains steps you can follow to create a sample chart, to use that sample chart as the basis for a user-defined chart format, and to apply that user-defined format to a another sample chart.



To create a sample chart
  In a new worksheet, enter the following data:    A1: Beth    B1: 95 A2: Joe    B2: 90 A3: Mary   B3: 85 A4: John   B4: 80  Select cells A1:B4, and press F11.  Format the chart.    Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition ---

a. On the Chart menu, click Chart Type.

b. In the Chart Type dialog box, Standard Types tab, click Pie, then click OK.

c. On the Chart menu, click Chart Options.

d. On the Titles tab, click in the Chart title box and type

My User-Defined Chart

and click OK.

Microsoft Excel Versions 5.0 and 7.0

a. On the Format Menu, click Chart Type.

b. In the Chart Type dialog box, click Pie, and then click OK.

c. On the Insert menu, click Titles.

d. In the Titles dialog box, click the Chart Title option under Attach Text To and then click OK. Type the following:

My User-Defined Chart

and then press ENTER. 

Creating a User-Defined Chart Format Based on the Sample Chart
  Switch to the chart sheet that contains the sample chart. <pre class="fixed_text">   Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition ---

a. On the Chart menu, click Chart Type.

b. On the Custom Type tab, click "User-defined" and click Add.

c. In the Add Custom Chart Types dialog, type the following in the Name box:

My Custom Chart

(Optional) In the Description box, type a brief description of      the chart, and click OK.

Microsoft Excel Versions 5.0 and 7.0

a. On the Format menu, click AutoFormat.

b. In the AutoFormat dialog box, under Formats Used, select the User Defined option, and then click Customize. In the User-Defined AutoFormats dialog box, click Add.

c. In the Add Custom AutoFormat dialog box, type the following name:

My Custom Chart

(Optional) In the Description box, type a brief description of      the chart, and click OK. </li></ol>

Applying a User-Defined Chart Format to Another Chart
  In a new worksheet, enter the following data: <pre class="fixed_text">   A1: David    B1: 95 A2: Jenny   B2: 90 A3: Tom     B3: 85 A4: Linda   B4: 80 </li>  Select cells A1:B4, and then press F11. A new chart sheet should be created with a two-dimensional column chart, and this chart sheet should be the active sheet in the workbook. <pre class="fixed_text">   Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition ---

a. On the Chart menu, click Chart Type.

b. In the Custom Types tab, click User-defined.

c. In the Chart type box, click My Custom Chart, and click OK.

The chart should be formatted with the formatting of the user- defined chart.

Microsoft Excel Versions 5.0 and 7.0

a. On the Format menu, click AutoFormat.

b. In the AutoFormat dialog box, click User-Defined in Formats Used.

c. In the Formats box, click My Custom Chart, and click OK. </li></ol>

<div class="references_section">