Information for Chart

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. 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

I have more questions than any answer.

What are you plotting? In what kind of a chart? Where does the 22%
come from? Is there some other column that contains that number? How
do you get a legend of '15.68% XYZ Company'?

--
Regards,

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

In article <00eb01c3b053$ed3c1de0$a301280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> 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. 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
>