Stacked Bar Chart Showing the Difference

[exeldc]

I keep trying to make a stacked bar chart showing the difference between two sets of data, but excell keeps totalling them rather then moving one ahead of the other and showing the difference.

Is there any way that can be done? Data is below.

	October	November	December
Amount Used	45	45	45
Amount Remaining	40	45	44

<COLGROUP><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6363" width=174><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><TBODY>
</TBODY>

 

[Andrew Poulsom]

Add a row that calculates the difference between the amount used and the amount remaining. Then plot amount remaining and that difference so that amount used is the value at the top of the stack.

 

[exeldc]

What about if I want the amount remaining at the top of the stack?

 

[Andrew Poulsom]

Reverse the series order.

 

[exeldc]

Ok so I got that how I wanted it. Now here is the fun part....

Lets say I have a Quarter where I spend too much. Is there any way I can have a new stack w a color for anything over $45? As of now the only linked items are the months, used, and remaining. Also in the current chart any negative values go under the axis.

	October	November	December
Target Amount	$45	$45	$45
Amount Used	$28	$33	$50
Amount Remaining	$17	$12	($5)

<COLGROUP><COL style="WIDTH: 131pt; mso-width-source: userset; mso-width-alt: 6363" width=174><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><TBODY>
</TBODY>

 

[Andrew Poulsom]

Maybe this will help you:

Stacked Column Charts that Cross the X Axis