Microsoft KB Archive/265936

= Works: Pie Chart Is Not Displayed in Worksheet =

Article ID: 265936

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * 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.

Additional query words: kbimu

Keywords: kbaddin kbbug kbnofix KB265936

-

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

© Microsoft Corporation. All rights reserved.