LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Stacked column with negative values

I want to make a stacked column that has 4 variables, two of which are always
zero or positive and two which are always zero or negative. The four
together make a net sum. Excel seems to start my positive and negative sets
at zero and stack in both directions. The result is the column is taller
than it is supposed to be because it is not debited the negative values. How
can I change this so that my column is as tall as the net sum of the 4
values? For example:

A 5
B 8
C -2
D -7
Sum = 5+8-2-7 = 4

My column should be 4 tall, with a switch from A to B at -1, a switch from B
to C at -9, a switch from C to D at -11, and D ends at -18.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
Return Range of Numerical Values in Single Column based on Frequency Percentage Sam via OfficeKB.com Excel Worksheet Functions 9 October 28th 05 11:01 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
How to average a column, but exclude zero AND negative values? KMHarpe Excel Discussion (Misc queries) 1 July 20th 05 10:06 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"