Charting: Displaying cumulative totals at top of stacked columns

Hi,

I'm having some trouble displaying the cumulative total at the TOP of each
of my two stacked columns. Right now, only one of the columns have the total
value on top while the other one has it in the middle. To be more specific,
this is the exact scenario:
I'm trying to graph the revenue data of 2005 and expected of 2009. So there
are two stacked columns in this graph. And these columns can be stacked by
different product revenues. I want to show the cumulative total of each
stacked column, but the shorter 2005 column displays the total value half-way
up the column instead of at the top of the column. I used the steps
recommended by the following website:
http://www.andypope.info/charts/StackColTotal.htm
but I still can't solve this problem.

Any help would be much appreciated! And I have an example file if that
would make the question clearer.

Thanks in advance,
Jean

Hi Jean,

If you want to email me the example file I will take a look see.

Cheers
Andy

Jean wrote:
Hi,

I'm having some trouble displaying the cumulative total at the TOP of each
of my two stacked columns. Right now, only one of the columns have the total
value on top while the other one has it in the middle. To be more specific,
this is the exact scenario:
I'm trying to graph the revenue data of 2005 and expected of 2009. So there
are two stacked columns in this graph. And these columns can be stacked by
different product revenues. I want to show the cumulative total of each
stacked column, but the shorter 2005 column displays the total value half-way
up the column instead of at the top of the column. I used the steps
recommended by the following website:
http://www.andypope.info/charts/StackColTotal.htm
but I still can't solve this problem.

Any help would be much appreciated! And I have an example file if that
would make the question clearer.

Thanks in advance,
Jean

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info