Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reformatting question
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reformatting question
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reformatting Cells | Excel Discussion (Misc queries) | |||
Reformatting | Excel Discussion (Misc queries) | |||
Help With Reformatting | Excel Discussion (Misc queries) | |||
need help reformatting spreadsheet | Excel Discussion (Misc queries) | |||
REformatting PivotChart | Excel Programming |