Microsoft KB Archive/61109

Works: Charting a Series

PSS ID Number: Q61109 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SUMMARY =

If charts are not displaying correctly, unnecessary cells may have been selected.

= MORE INFORMATION =

When charting in Works, make sure only the data selected for the series is highlighted in the Spreadsheet. It is easy to accidentally highlight additional cells or even the whole column of cells. If this happens, the graph will be incorrect or will appear to not be there at all.

For example, consider the following scenario:


 * 1) Cells A1-A5 have the numbers 1-5, respectively.
 * 2) Choose this to be the X series.
 * 3) Cells B1-B3 have the numbers .3, 4, and .5, respectively.
 * 4) Choose this to be the first Y series.
 * 5) Format this to be a bar or line graph.

When the graph is viewed, a thick dark line will appear on the X-axis. On the Y-axis, a thick line will appear for a bar chart, or dots will appear for a line chart.

The graph is correct but cannot accurately display the information selected as the X and Y series.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.