Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a pie chart with data lables added, including the category, value and
percentage. I want to format my lables so the value is displayed as a currency, and the percentage as a regular percentage. When I format the lable and set the number format to currency, Excel then displays the value as a plain value but formats the percentage to become currency. e.g. At first the segment says "alice, 1, 17%", I change the number formatting to currency and it becomes "alice, 1, £0.17". I actually wanted it to be "alice, £1.00, 0.17%". Is this the intended behaviour? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Incorrect Data Labels on Column Chart | Charts and Charting in Excel | |||
Incorrect date in line chart in Excel. | Charts and Charting in Excel | |||
Chart labels disappear - How do I refresh the chart? | Charts and Charting in Excel | |||
Percentage Incorrect In Pie Chart | Charts and Charting in Excel | |||
XY chart with labels | Charts and Charting in Excel |