Column Chart with data labels for percent and value?

[Kim]

I want to create a column chart that displays data labels
for both percent and value. Is this possible?

Each column is stacked with 2 values, for instance:
May '03 values:
series A = 10
series B = 10
sum = 20

I want the column for May '03 to consist of a series A
percent of 50%, a series B stacked on that, also
displaying 50%, and another data label on top of the bar
displaying 20.

Right now, I just manually add a text box for each value,
every time a new month is added.

Is there an easier way? I have a picture of the chart, if
you need it.

Thanks!
Kim

 

[Andy Pope]

Hi Kim,

Store you display information in cells and then link the datalabels to
those cells.
Either of the two addin below will allow you to link datalabel text with
cells.

Rob Bovey's XY Chart Labeler:
http://www.appspro.com/utilities/utilities.asp

JWalk Chart Tools:
http://j-walk.com/ss/excel/files/charttools.htm

I want to create a column chart that displays data labels
for both percent and value. Is this possible?

Each column is stacked with 2 values, for instance:
May '03 values:
series A = 10
series B = 10
sum = 20

I want the column for May '03 to consist of a series A
percent of 50%, a series B stacked on that, also
displaying 50%, and another data label on top of the bar
displaying 20.

Right now, I just manually add a text box for each value,
every time a new month is added.

Is there an easier way? I have a picture of the chart, if
you need it.

Thanks!
Kim

--

Cheers
Andy

http://www.andypope.info