Pls HLP - Label Above Column in Stacked Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dee - 25 Jul 2007 09:18 GMT

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!

Signature

Thanks!

Dee

Reply to this Message

Andy Pope - 25 Jul 2007 09:56 GMT

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

Signature

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

>I am working with stacked "floating" charts and have almost succeeded in
> doing what I want...
[quoted text clipped - 6 lines]
>
> Thanks so much!

Reply to this Message

dee - 25 Jul 2007 10:32 GMT

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.

Signature

Thanks!

Dee

> Hi,
>
[quoted text clipped - 18 lines]
> >
> > Thanks so much!

Reply to this Message

Andy Pope - 25 Jul 2007 12:54 GMT

Assuming your data is in cells A1:D9 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 D2:D9
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

Signature

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..
[quoted text clipped - 49 lines]
>> >
>> > Thanks so much!

Reply to this Message