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
WINDOWS
Summary:
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:
- From the Chart Format menu, choose Main Chart.
- 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.