Quattro Pro Column Graph Displays Negative Values
Article ID: 124233
Article Last Modified on 8/15/2003
APPLIES TO
- Microsoft Excel 95a
- Microsoft Excel 5.0c
This article was previously published under Q124233
SYMPTOMS
In Microsoft Excel, when you open a Quattro Pro file that contains a
stacked column graph, negative values are displayed differently on
the graph than when you open the file in Quattro Pro.
CAUSE
This behavior occurs because when you create a stacked column graph
in Quattro Pro, negative values are graphed as positive percentage
values. However, Microsoft Excel plots negative numbers using the
negative value, even with a stacked column chart. This is by design
of Microsoft Excel.
WORKAROUND
To work around this behavior in Microsoft Excel, use any of the
following methods.
Method 1:
Change the negative values on your worksheet to positive values.
Method 2:
Use the ABS() function to create a chart using the absolute value
of the data that you want to chart.
MORE INFORMATION
Quattro Pro is manufactured by Borland International, a vendor
independent of Microsoft; we make no warranty, implied or otherwise,
regarding this product's performance or reliability.
REFERENCES
For more information about the Stacked Column Chart AutoFormat Button,
choose the Search button in Help and type:
Additional query words: 5.00c XL
Keywords: KB124233