Pls HLP - Label Above Column in Stacked Chart

[dee]

I am working with stacked "floating" charts and have almost succeeded in
doing what I want...

However, I would like both the value of the column, plus the % of the total,
to appear ABOVE the columns.

Is there any way of doing this besides a text box?

Thanks so much!

 

[Andy Pope]

Hi,

Create a set of cells which contains the total. Plot this as a line series.
You can then use the line series data labels. Position these to be plotted
above the point and then remove all formatting from the line are markers.

I explain a similar technique here, but use a column series instead of line.
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

 

[dee]

I think I'm lost. I have been up all night working on this, so am very
tired..

I managed to get the look I want by dragging (individually) the value of
each column, plus had added a % column who columns I hid, but kept the %
value and moved them up to the top of the column as well. It worked, but is
manual.

Your way is probably automatic, but I'm not understanding it.

This is my data:
Product Last Year Current Year This year %
LLM002 125 151 (22%)
LLM003 145 95 (14%)
LLM004 74 135 (20%)
MNO443 99 154 (22%)
MNO444 54 77 (11%)
MNO445 44 55 (8%)
MNO446 11 24 (3%)
Total 691 (100%)

I hide last years pattern and line to create the floating affect, and do the
same for the %. Then I manually take each box and move it up and out of the
column.
--
Thanks!

Dee

Hi,

Create a set of cells which contains the total. Plot this as a line series.
You can then use the line series data labels. Position these to be plotted
above the point and then remove all formatting from the line are markers.

I explain a similar technique here, but use a column series instead of line.
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

 

[Andy Pope]

Assuming your data is in cells A19 add this formula to E2 and copy down to
E9

=B2+C2

Now add a series to the chart based on the range E2:E9
Select this series and change the chart type to line.
Via the Format dialog change the line to the secondary axis.
Via the Source Data dialog set the category labels for the secondary axis to
be D29
Again format the line series to display Category data labels. Set marker and
line to none.
Format data label to be positioned above point.
Finally delete the secondary Y axis. The labels should now be positioned
above the stacked columns.

Cheers
Andy

--

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

I think I'm lost. I have been up all night working on this, so am very
tired..

I managed to get the look I want by dragging (individually) the value of
each column, plus had added a % column who columns I hid, but kept the %
value and moved them up to the top of the column as well. It worked, but
is
manual.

Your way is probably automatic, but I'm not understanding it.

This is my data:
Product Last Year Current Year This year %
LLM002 125 151 (22%)
LLM003 145 95 (14%)
LLM004 74 135 (20%)
MNO443 99 154 (22%)
MNO444 54 77 (11%)
MNO445 44 55 (8%)
MNO446 11 24 (3%)
Total 691 (100%)

I hide last years pattern and line to create the floating affect, and do
the
same for the %. Then I manually take each box and move it up and out of
the
column.