If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pie chart
Good day everybody,
I hope someone can help me and my colleague. We are trying to do a pie chart. A pie chart allows data label option of : * none * Show value * Show percent * Show label * Show label and percent But we would like to show pie charts with the following option : 1. label, value and percent 2. value and percent Is both possible? Thank you in advance and have a nice day. Best regards, Julie |
#2
|
|||
|
|||
Pie chart
Put whatever you want in a separate range of cells and use Rob Bovey's
free add-in, XY Chartlabeler, downloadable from www.appspro.com. For example, suppose the labels are in A2:A5 and the values in B2:B5. Then, in C2 enter =A2&", " & B2 &" ("&TEXT(B2/SUM($B$2:$B$5),"0.0%") &")" Copy down to C3:C5. Now, when using the add-in, specify C as the data labels range -- Regards, Tushar Mehta MS MVP Excel 2000-2003 www.tushar-mehta.com Excel, PowerPoint, and VBA tutorials and add-ins Custom Productivity Solutions leveraging MS Office In article , says... Good day everybody, I hope someone can help me and my colleague. We are trying to do a pie chart. A pie chart allows data label option of : * none * Show value * Show percent * Show label * Show label and percent But we would like to show pie charts with the following option : 1. label, value and percent 2. value and percent Is both possible? Thank you in advance and have a nice day. Best regards, Julie |
#3
|
|||
|
|||
Pie chart
I have another solution:
Your earlier data say is in this format. label - value - Percent in three different columns. Please change the data to the following format: Label& value & percent in one column and value in another Useing this, please create a pie chart and choose label alone to be displayed. Hope this work around will help you. -----Original Message----- Put whatever you want in a separate range of cells and use Rob Bovey's free add-in, XY Chartlabeler, downloadable from www.appspro.com. For example, suppose the labels are in A2:A5 and the values in B2:B5. Then, in C2 enter =A2&", " & B2 &" ("&TEXT(B2/SUM ($B$2:$B$5),"0.0%") &")" Copy down to C3:C5. Now, when using the add-in, specify C as the data labels range -- Regards, Tushar Mehta MS MVP Excel 2000-2003 www.tushar-mehta.com Excel, PowerPoint, and VBA tutorials and add-ins Custom Productivity Solutions leveraging MS Office In article , says... Good day everybody, I hope someone can help me and my colleague. We are trying to do a pie chart. A pie chart allows data label option of : * none * Show value * Show percent * Show label * Show label and percent But we would like to show pie charts with the following option : 1. label, value and percent 2. value and percent Is both possible? Thank you in advance and have a nice day. Best regards, Julie . |
Thread Tools | |
Display Modes | |
|
|