LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 11
Default Pie Chart labels seem incorrect

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Incorrect Data Labels on Column Chart SM Charts and Charting in Excel 0 June 7th 06 04:39 PM
Incorrect date in line chart in Excel. gobonniego Charts and Charting in Excel 0 June 7th 06 01:01 AM
Chart labels disappear - How do I refresh the chart? jcloydjcloyd Charts and Charting in Excel 0 March 30th 06 07:49 PM
Percentage Incorrect In Pie Chart Gladys Charts and Charting in Excel 1 February 13th 06 06:23 PM
XY chart with labels DSK_7 Charts and Charting in Excel 1 June 24th 05 08:50 PM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"