Stacked column with negative values

G

Guest

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

Guest

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

Negative Values in Stacked Bar Charts 3
Stacked column charts that cross the X Axis 1
Excel 07 - Stacked Chart Labels on Negative Values 1
stacked column chart with negative values 5
100% stacked column chart with negative numbers 2
Stacked bar chart, Excel 2007 3
Stack bar charts with positive and negative numbers 2
Stacked bars with textlegends in each stacked bar 7

Top