Microsoft KB Archive/926368

= How to create a custom chart format in Excel 2007 =

Article ID: 926368

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-





For a Microsoft Office Excel 2003 version of this article, see 214265.



INTRODUCTION
In Microsoft Office Excel 2007, you can create a custom chart format to produce charts that have a consistent look. This article describes how to create a sample chart, how to use that sample chart to create a custom chart format, and how to apply that custom format to another sample chart.



How to create a sample chart
 In Excel, create a new worksheet. Enter the following data in the worksheet.  Select cells A1 to B4, and then press F11. Format the chart. To do this, follow these steps:  On the Ribbon, click the Design tab, and then click Change Chart Type in the Type group. In the Change Chart Type dialog box, click Pie in the left pane, and then click OK. On the Ribbon, click the Layout tab, click Chart Title in the Labels group, and then click Above Chart in the list.</li> Click anywhere inside the inserted chart title, and then type my custom chart .</li></ol> </li></ol>

How to use the sample chart to create a custom chart format
<ol> In Excel, switch to the chart sheet that contains the sample chart.</li> On the Ribbon, click the Design tab, and then click Save As Template in the Type group.</li> In the Save Chart Template dialog box, type my custom chart in the File Name box, and then click Save.

Note The file is saved as a .crtx file to the following location:

C:\Documents and Settings\ \Application Data\Microsoft\Templates\Charts

</li></ol>

How to apply a custom chart format to another sample chart
<ol> In Excel, create a new worksheet. Enter the following data in the worksheet. </li> Select cells A1 to B4, and then press F11.</li> On the Ribbon, click the Design tab, and then click Change Chart Type in the Type group.</li> In the Change Chart Type dialog box, click Templates in the left pane, click my custom chart in the right pane, and then click OK.</li></ol>

The chart is formatted in the custom chart format.

Additional query words: XL2007 Excel2007

Keywords: kbhowto kbinfo kbformat kbexpertisebeginner KB926368

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.