Microsoft KB Archive/128139

Mac Works: Chart Values Incorrect with Non-US Decimal Separators

PSS ID Number: Q128139 Article last modified on 10-22-1998

4.0 4.0a 4.0b

MACINTOSH

=
=========================================================

= SYMPTOMS =

When you are in a Works Spreadsheet, charts do not show correct values. The problem occurs if you use a non-U.S. decimal separator (such as a comma) and set minimum value for the Y axis.

= RESOLUTION =

The problem can be corrected using either of the following options.

First Option:

 * 1) From the Apple menu, choose Control Panels.
 * 2) Double-click Numbers.
 * 3) In the Separators box, click the Decimal down arrow and choose the period. Then, click the Thousands down arrow and choose anything other than the period.
 * 4) Close the Numbers control panel.
 * 5) Delete your existing chart. Re-create your chart. Your new chart now shows correct values.

Second Option:

 * 1) Double-click your chart.
 * 2) In the Define Chart box, go to the Vertical Axis section. Highlight the Minimum Value box, and type a zero. Click OK.

KBCategory: kbusage kbenv kbprb KBSubcategory: mwksss macworkskb

Additional reference words: 4.00 mac m_works foreign currency figures dollars error ====================================================================== Keywords : kbenv Version : 4.0 4.0a 4.0b Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.