Microsoft KB Archive/151445

= How to Create a Spiral Chart =

Article ID: 151445

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 Q151445




 * Microsoft Excel for Windows 5.0c|5.0c
 * Microsoft Excel for Windows 95 7.0a|7.0a
 * Microsoft Excel for the Macintosh 5.0|5.0
 * Microsoft Excel for the Macintosh 5.0a|5.0a



SUMMARY
It is possible to create a chart in Microsoft Excel that resembles a spiral or spirograph. The spiral chart is an XY Scatter chart that plots the series of values 1 through 128 against the cosines of those values.



MORE INFORMATION
To create the chart, follow these steps.

Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition
 Enter the following data in Sheet1 of a new workbook:

A1 : 1

A2 : 2

A3 : 3

A4 : 4

A5 : 5

A6 : 6

A7 : 7

A8 : 8

A9 : 9

A10: 10

 Save the workbook as Test.xls . On the Insert menu, point to Name, and then click Define.

 In the Names In Workbook box, type Numbers. Type the following formula in the Refers To box =ROW($A$1:$A$125), and then click Add. In the Names In Workbook box, type X_Value. Type the following formula in the Refers To box =SIN(Numbers), and then click Add. In the Names In Workbook box, type Y_Values. Type the following formula in the Refers To box =COS(Numbers), and then click OK.</li></ol> </li> Select the range A1:A10 on the worksheet.</li> On the Insert menu, click Chart.</li> In the "Chart Wizard - Step 1 of 4 - Chart Type" dialog box, make sure the Chart Type selected is Column, and the sub-type selected is the first chart example on the top row of examples. Click Finish.

This places an embedded chart on your worksheet.</li> On the Chart menu, click Location, and in the Chart Location dialog box, click As New Sheet. Click OK.</li> On the Chart menu, click Source Data.</li> Click the Series tab.

<ol> In the "Values" RefEdit box, type =test.xls!y_values .</li> In the "Category (x) axis labels" RefEdit box, type =test.xls!x_values .</li> Click OK.</li></ol> </li> On the Chart menu, click Chart Type. Under Chart Type click X-Y (Scatter), and then under "Chart sub-type" click the first sample chart on the third row of the sample chart sub-types. Click OK.</li> Double-click the series and in the Format Data Series dialog box click the Patterns tab.</li> Click None under the Marker options, and then click OK.</li> Double-click the Y axis and in the Format Axis dialog box, click the Patterns tab. Click the None option for: Axis, Major Tick Mark Type, and Tick Mark Labels. Click OK.</li> Double-click the X axis and in the Format Axis dialog box click the Patterns tab. Click the None option for: Axis, Major Tick Mark Type, and Tick Mark Labels. Click OK.</li></ol>

Microsoft Excel Versions 5.0 and 7.0
<ol> Enter the following data in a worksheet:

A1 : 1

A2 : 2

A3 : 3

A4 : 4

A5 : 5

A6 : 6

A7 : 7

A8 : 8

A9 : 9

A10: 10

</li> On the Insert menu, point to Name, and then click Define.

<ol style="list-style-type: lower-alpha;"> <li>In the Names In Workbook box, type Numbers. Type the following formula in the Refers To box =ROW($A$1:$A$125), and then click Add.</li> <li>In the Names in Workbook box, type X_Values. Type the following formula in the Refers To box =SIN(Numbers), and then click Add.</li> <li>In the Names in Workbook box, type Y_Values. Type the following formula in the Refers To box =COS(Numbers), and then click Add.</li></ol> </li> <li>Select the following range of cells on the worksheet: A1:A10.

<ol style="list-style-type: lower-alpha;"> <li>On the Insert menu, click Chart, and then As New Sheet. In the ChartWizard box, click Next.</li> <li>Under "Select a chart type," click Column Chart, and then click Next.</li> <li>Under "Select a format for the Column chart," click chart type 1, and then click Finish.</li> <li>Double-click the data series.</li> <li>Click the Names and Values tab. In the Y Values box, type =<Sheetname>!Y_Values where <Sheetname> is the name of the worksheet where this name is defined).</li> <li>Click the X Values tab. In the X Values box, type =<Sheetname>!X_Values where <Sheetname> is the name of the worksheet where this name is defined). Click OK.</li> <li>On the Format menu, click Chart Type. Click XY (Scatter). Click OK.</li> <li>Double-click the Y axis. Click the Patterns tab. Select None under Axis, Tick Mark Type Major, and Tick Mark Labels group boxes. Click OK.</li> <li>Double-click the X axis. Click the Patterns tab. Select None under Axis, Tick Mark Type Major, and Tick Mark Labels group boxes. Click OK.</li> <li>Double-click the data series. Click the Patterns tab. In the Marker group box, select None. Click OK.</li> <li>Click the Legend. On the Edit menu, click Clear All.</li></ol> </li></ol>

<div class="references_section">

For Microsoft Excel 7.0
For more information about charting in Microsoft Excel, click Answer Wizard on the Help menu and type:

creating and formatting charts

For Microsoft Excel 5.0
For more information about charting in Microsoft Excel, click the Search button in Help and type:

chart

Additional query words: XL98 XL97 XL7 XL5 XL

Keywords: kbhowto KB151445

-

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

© Microsoft Corporation. All rights reserved.