Reformatting question
 

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

Reformatting question
 

Sent a private workbook with chart.
Hope it helps.

--
Don Guillett
SalesAid Software

"Julie" wrote in message
...
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

Reformatting question
 

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

Julie
-----Original Message-----
Sent a private workbook with chart.
Hope it helps.

--
Don Guillett
SalesAid Software

"Julie" wrote in
message
...
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




.

Reformatting question
 

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.

--
Don Guillett
SalesAid Software

"Julie" wrote in message
...
Hi Don,
Where did you send it? Thanks for your help and have a
great weekend!

Julie
-----Original Message-----
Sent a private workbook with chart.
Hope it helps.

--
Don Guillett
SalesAid Software

"Julie" wrote in
message
...
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




.