AJP Excel Information

Stacked positive/negative Chart

This chart uses a combination of built-in stacked bar, a reconfigured side by side bar and some formula.

It tackles the problem of maintaining legend order and the bars not obscuring each other.

The download contains a step by step example.