Reformatting question

[Julie]

Hi All,

I have a summary page and I want to create a chart using
that data. My only problem is that I have a percentage
field 15.675 that imported in a custom format of "0.000_-
". I tried to change the format of the field to a number,
but my output shows 1567.50 instead of 15.675, so I kept
the format as custom and I inserted a new field and typed
in =(E1/100), it gave me the value of .15675. I changed
the field to a percentage field with two decimal places
and I got 15.68% which is what I wanted.

Well, I went into make my chart and the legend values
show the right value (Ex: 15.68% XYZ Company), but the
value on my data labels show 22%. Why is that? I tried
doing some adjustments, but I can't get my data label
values to show the correct value. Is there a way that I
can use VBA code to reformat the cell value to .15675?
Any suggestions? Any help would be greatly appreciated.
I have posted an example of my summary page below.

ABC 752,978.77 15.675
DEF 548,201.86 11.412
GHI 428,855.30 8.928
JKL 399,946.43 8.326
MNO 297,806.67 6.200
HIJ 257,708.13 5.365
KLM 241,128.61 5.020
NOP 179,613.02 3.739
QRS 134,473.20 2.799
TUV 130,189.63 2.710

Thanks in advance and have a great weekend!

Julie

 

[Don Guillett]

Sent a private workbook with chart.
Hope it helps.

 

[Julie]

Hi Don,
Where did you send it? Thanks for your help and have a
great weekend!

Julie

 

[Don Guillett]

I sent it to the address given here.
How about a real one. You can email me direct and I will reply with the wb.