Microsoft KB Archive/116119

= Works: Radar Charts Are Limited to 15 Categories =

Article ID: 116119

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q116119



SUMMARY
Radar charts in Works are limited to 15 Category (X) Series axes. When you first create the chart, if the selected area includes more than 15 rows (and each series is in a column) or 15 columns (and each series is in a row), the data will be truncated to use just the first 15 elements in the series.



MORE INFORMATION
If more than 15 categories are selected when you create the chart, only the first 15 will be used to create the chart. The Value (Y) Series shown in the Series dialog box when you click Series in the Edit menu still indicates the categories selected when you created the chart.

Steps to Reproduce Situation

 * 1) Create a new spreadsheet in Works.
 * 2) Enter a sequence of numbers from 1 to 20 in cells A1 through A20, respectively.
 * 3) Select A1:A20 and from the Tools menu, click Create New Chart.
 * 4) Click Radar from the What type of chart do you want? list. Click OK.

The chart created will have only 15 Category (X) Series axes even though 20 categories were selected in step 3 above.

For more information about creating or modifying charts, see the following in the "Microsoft Works for Windows User's Guide" for version 3.0:


 * Pages 226-234, "Creating a chart"


 * Pages 235-250, "Changing a chart type"

For more information about how to perform this task in Works, see your Works printed documentation or online Help.

Additional query words: 3.00 3.00a 4.00 4.00a 4.50 4.50a w_works kbhowto ch Lost Missing axis Y X 16 SS Short

Keywords: kbhowto kbinfo KB116119

-

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

© Microsoft Corporation. All rights reserved.