You are currently offline, waiting for your internet to reconnect

XL2000: Polar Charts Are Available in Microsoft Office Chart Component

This article was previously published under Q232878
The Microsoft Office Chart Component supports a new type of chart called a polar chart. However, Microsoft Excel 2000 does not include this new type of chart.
A polar chart compares the relationship of angles and distances. Excel 2000 does have radar charts, but they are not the same as polar charts. Radar charts show the relationship of values to a center point or origin.

To create a polar chart, follow these steps.

Create a New Web Page in Microsoft FrontPage

  1. Open Microsoft FrontPage.
  2. On the File menu, point to New, and then click Page.
  3. In the New dialog box, click the Normal Page template, and then click OK.

Insert the Spreadsheet Component

You must have a valid data source for the Chart Component prior to inserting it. You can insert the Spreadsheet Component first so that the Chart Component automatically recognizes it as the data source.
  1. In FrontPage, press ENTER a few times to insert some lines.
  2. On the Insert menu, point to Component, and then click Office Spreadsheet.
  3. Type the following data into the Spreadsheet Component:
    A1: Distance        B1: AngleA2: 3               B2: 45   A3: 7               B3: 90A4: 5               B4: 180A5: 9               B5: 220A6: 4               B6: 340					

Insert the Chart Component

NOTE: Unlike the Excel Chart Wizard, you must select your data source and all other available options within the Office Chart Wizard while it is active. After you close the Office Chart Wizard, you cannot use it again for that Chart object; it becomes unavailable. If you then want to make any changes to the chart that require the Office Chart Wizard, you must delete the Chart object and insert it again. This will cause the Office Chart Wizard to once again be displayed.

To insert the Chart Component, follow these steps:
  1. Click one of the blank lines at the top of the Web page.
  2. On the Insert menu, point to Component, and then click Office Chart.

    A Chart object is inserted and the Microsoft Office Chart Wizard dialog box is displayed.
  3. In the Microsoft Office Chart Wizard - Step 1 of 3 dialog box, click Polar in the Chart type list.
  4. Under Chart sub-type, click the type of polar chart that you want. Click Next.
  5. In the Microsoft Office Chart Wizard - Step 2 of 3 dialog box, ensure that Microsoft Office Spreadsheet is selected under Available data sources, and click Next.
  6. In the Microsoft Office Chart Wizard - Step 3 of 3 dialog box, set the range from which this chart derives its data. Click the button next to Set this chart's data in one step.
  7. In the Data Range dialog box, type =A2:B6 in the Data range box.
  8. Click Columns, and then click OK.
  9. Click Finish.
To view your Web page without saving it, click the Preview tab at the bottom of the window.
For more information about polar charts, locate and open the Msowcdch.chm file, located on your Microsoft Office 2000 CD. Type polar charts in the box on the Search tab, and then click Display to view the topics available.
XL2000 webcalc webchart

Article ID: 232878 - Last Review: 10/06/2003 16:05:00 - Revision: 3.0

  • Microsoft Excel 2000 Standard Edition
  • Microsoft Office Web Components
  • kbprb kbpending KB232878