Need a stacked bar chart with each stack representing a month

K

KellyT@HLI

Need a stacked bar chart with each section of the stack representing a month,
but some of the months have a negative number. The chart moves the negative
number to the bottom of the graph, when I need it to show in monthly order.

Any help on this would be great!
 
B

bj

I agree that it is annowing.

What I do is plot the absolute values of the data and selectively change the
colors for the negative to indicate negative.
 
J

Jon Peltier

How do you accurately represent the total of the stack if some of the
numbers are negative? The stack will be wrong by twice the sum of the
negatives.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
K

KellyT@hli

That's a good idea!
Thanks bj!
KellyT

bj said:
I agree that it is annowing.

What I do is plot the absolute values of the data and selectively change the
colors for the negative to indicate negative.
Click to expand...
 
Top