Microsoft KB Archive/214265

= XL: How to Create a User-Defined Chart Format =

Article ID: 214265

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q214265



For a Microsoft Excel 97 and earlier or Microsoft Excel 98 Macintosh Edition or earlier version of this article, see 142124.



SUMMARY
In Microsoft Excel, you can produce charts with a consistent look by creating a user-defined chart format. This article describes how to create a sample chart, how to use that sample chart as the basis for a user-defined chart format, and how to apply that user-defined format to 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.  On the Chart menu, click Chart Type. Click the Standard Types tab. Click Pie, and then click OK.</li> On the Chart menu, click Chart Options.</li> Click the Titles tab.</li> In the Chart title box, type

My User-Defined Chart

and click OK.</li></ol> </li></ol>

Creating a User-Defined Chart Format Based on the Sample Chart
<ol> Switch to the chart sheet that contains the sample chart.</li> On the Chart menu, click Chart Type.</li> Click the Custom Types tab.</li> Under Select from, click User-defined and click Add.</li> In the Name box, type the following:

My Custom Chart

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

Applying a User-Defined Chart Format to Another Chart
<ol>  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.

You should see a new chart sheet with a two-dimensional column chart. This chart sheet should be the active sheet in the workbook.</li> On the Chart menu, click Chart Type.</li> On the Custom Types tab, click User-defined.</li> 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.</li></ol>

<div class="references_section">