Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/38359

From BetaArchive Wiki

Area Charts with Negative Values in Windows Excel PSS ID Number: Q38359 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00



When creating an area chart, Excel automatically uses the absolute values of the worksheet data. To have the area chart reflect the negative values, you must adjust the formatting by doing the following:

  1. From the Chart Format menu, choose Main Chart.
  2. From Excel 3.0, select the first Area Chart and choose OK. If you are using Excel 2.x, clear the Stacked check box under the Format Section, then choose OK.

Additional reference words: 2.0 2.00 2.1 2.10 3.0 3.00

Copyright Microsoft Corporation 1993.