| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data labels: Making the value currency & use % in a chart?
Is is possible to have in a pie chart BOTH the value with a currency format
and the 1,000 comma option on, with the percentage checked as well? |
|
#2
|
|||
|
|||
|
You might have to construct your own labels in an extra worksheet range,
using a formula like this: =TEXT(B2,"$#,000.00")&CHAR(10)&TEXT(B2/SUM($B$2:$B$10),"0.0%") then use a utility like those below to assign these labels to the pie wedges: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ AKO wrote: Is is possible to have in a pie chart BOTH the value with a currency format and the 1,000 comma option on, with the percentage checked as well? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| How do I add column A data labels to a scatter of columns B and C? | Charts and Charting in Excel | |||
| Getting data labels right.... | Charts and Charting in Excel | |||
| Excel should let me align data labels in different series (Excel . | Charts and Charting in Excel | |||
Linear Mode
