Stacked column with negative values

S

Sam

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.
 
H

HEK

Hi Sam:
You obviously cannot display a negative length, only a negative value. I
don't know why you want to have a stacked column: cannot you use a
side-by-side column instead? Than show also the Totals in a column (so 5
col's in total).
HTH,
GL,
Henk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
Cumulative formula for word table 0
Stacked Clustered Column? 1
Stacked column charts that cross the X Axis 1
Excel 07 - Stacked Chart Labels on Negative Values 1
Negative Values in Stacked Bar Charts 3
100% stacked column chart with negative numbers 2

Top