Microsoft KB Archive/63141

Works: Incorrect Pie Chart Data Format, Blank Screen

PSS ID Number: Q63141 Article last modified on 10-16-1998

2.00 3.00

MS-DOS

=
========================================================= 2.00 3.00 MS-DOS kbother

= SYMPTOMS =

If a range has been selected along a horizontal axis for a pie chart and if the Works Spreadsheet has been formatted with an empty column for spacing between columns, the chart will display properly. However, when you choose Data Format from the Format menu (ALT, T, D) there will be more slices than are actually in the chart.

For example, with the formatting of the spreadsheet displayed below, selecting the range A1:F2 results in a chart with three slices. However, in Format Data Format (ALT, T, D), five slices are described.

= WORKAROUND =

The solution is to delete the empty columns. In the spreadsheet below, delete columns C and E. Spacing between columns of numbers can be provided by choosing Column Width from the Format menu (ALT, T, W) and widening the columns. Then choose Style from the Format menu and select Center from the Alignment field (ALT, T, S, C) to center the numbers in the columns.

For example, in the chart below, if a range such a A1:B5 is selected along a vertical axis, and if an empty column is inserted between the column of numbers and the labels, an empty screen will appear when you select Chart from the View menu (ALT, V, X) after Pie has been selected. In the chart below, there will be the range, A1:C5, selected with an empty column B.

The solution to the problem encountered in the previous paragraph is to delete the empty column B.

A           B       C      D       E      F 1 Outlet Quarter 1 Quarter 2 Quarter 3 2 Capitol Hill 30,000 29,700 49,500 3 Bellevue 34,500 49,500 59,400 4 Northgate 10,500 41,580 27,225 5 Wallingford 15,000 23,768 37,125 6 7 Average 22,500 36,135 43,313

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 2.00 3.00 =

Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.