Works: Pie Chart Is Not Displayed in Worksheet

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.

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.

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.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.