R
Rita Palazzi
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
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