Windows 2000
Office 2000
I have a series of numbers which represent a percentage of shipments for various
countries. I am showing this percentage in a bar chart. I have been asked to add
another indice for each country, which is an integer, as a label to each bar. I
went thru the process of adding a second axis, hiding it, and doing a hidden line
graph with the labels showing. This doesn't produce the wanted output because in
some cases the label for the hidden line graph is a long way away from the bar for
that country and doesn't look like a label, even tho I've toyed with the axis
scale. Basically, management wants the integer sitting on top of the % bar for
each country. I don't want to have to do a text box and change these every week.
Is there some way to choose a series as labels? I know this is confusing and
hope I've explained enough to get some input!
Thanks in advance for any help you can give. I'm putting the data structure below
as an example.
Rita Palazzi
Senior Engineer/FedEx Express
Country % Controllable Dwell Time (days)
HK 7.2% 1.8
JP 3.1% 0.9
CN 5.6% 3.0
TW 5.4% 0.8
SG 8.3% 1.9
MY 4.9% 1.4
KR 9.6% 1.1
PH 9.0% 1.0
TH 3.5% 1.3
AU 1.3% 0.6
Tushar Mehta - 15 Jan 2004 14:58 GMT
Use either of the addins: XY Chartlabeler (www.appspro.com) or Chart
Tools (www.j-walk.com). You will be able to add labels from any
column.

Signature
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
> Windows 2000
> Office 2000
[quoted text clipped - 28 lines]
> TH 3.5% 1.3
> AU 1.3% 0.6
Rita Palazzi - 15 Jan 2004 16:22 GMT
Have that and forgot all about it!! Worked like a charm. THANKS!!
Rita
> Use either of the addins: XY Chartlabeler (www.appspro.com) or Chart
> Tools (www.j-walk.com). You will be able to add labels from any
> column.
Tushar Mehta - 15 Jan 2004 17:44 GMT
You are welcome.

Signature
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
> Have that and forgot all about it!! Worked like a charm. THANKS!!
> Rita
>
> > Use either of the addins: XY Chartlabeler (www.appspro.com) or Chart
> > Tools (www.j-walk.com). You will be able to add labels from any
> > column.