Information for Chart

  • Thread starter Thread starter Julie
  • Start date Start date
J

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