XL: Quattro Pro Column Graph Displays Negative Values

ID: Q124233

5.00 5.00c 7.00 7.00a WINDOWS kb3rdparty

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a

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.

WORKAROUNDS

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:

   charts, column

Additional reference words: 5.00 5.00c 7.00

Version           : 5.00 5.00c 7.00 7.00a
Platform          : WINDOWS

Last Reviewed: March 29, 1997