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
 

======================================================================
 
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, version 4.0, 4.0a, and 4.0b
----------------------------------------------------------------------
 
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.