Need a stacked bar chart with each stack representing a month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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/
_______
 
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...
 
Back
Top