Series as labels on bar chart


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
 
Ad

Advertisements

R

Rita Palazzi

Have that and forgot all about it!! Worked like a charm. THANKS!!
Rita
 
Ad

Advertisements

T

Tushar Mehta

You are welcome.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top