Works: Pie Chart Is Not Displayed in Worksheet (265936)


The information in this article applies to:

  • Microsoft Works 6
  • Microsoft Works Suite 2001
  • Microsoft Works 7.0
  • Microsoft Works Suite 2002
  • Microsoft Works Suite 2003
This article was previously published under Q265936

SYMPTOMS

When you type data in a worksheet created in Works Spreadsheet, and you then use that data to create a new pie chart, the pie chart is not displayed in the worksheet.

CAUSE

This problem occur if the Use text in the first row of your selection as category names check box is not selected in the New Chart dialog box.

Works Spreadsheet is unable to chart text. As a result, it will not chart the text displayed in the first row of your selection as category names.

RESOLUTION

To work around this problem, use one of the following methods:

Method 1

  1. Click to select the Use text in the first row of your selection as category names check box.
  2. Start Works Spreadsheet.
  3. On the File menu, click Open.
  4. In the Open dialog box, browse to select your worksheet file, and then click Open.
  5. Click to select the cell range containing the data for the pie chart.
  6. On the Tools menu, click Create New Chart.
  7. In the New Chart dialog box, click the Basic Options tab, and then click Pie for the Chart type.
  8. Click the Advanced Options tab.
  9. Click to select the Use text in the first row of your selection as category names check box.
  10. Click OK.

Method 2

Remove the text from the first row of your selection:
  1. Start Works Spreadsheet.
  2. On the File menu, click Open.
  3. In the Open dialog box, browse to select your worksheet file, and then click Open.
  4. Click to select cell A1 (row containing the text).
  5. On the Insert menu, click Delete Row.

Method 3

  • Replace the text in the first row with numbers.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:9/22/2003
Keywords:kbAddIn kbbug kbnofix KB265936
©2003 Microsoft Corporation. All rights reserved.