Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
On the Chart Options there is an option DATA LABELS. This option lets you
print the following VALUE, PERCENT, LABEL and LABEL + PERCENT. Is there any way that you can print the Value and the Label. Or is there anyway you can modify any part of what you want to print beside the section of the pie chart. |
#2
![]() |
|||
|
|||
![]()
You can manually change the text within each data label. This is rather
tedious, so you can download one of the following Excel add-ins, which allow you to select a worksheet range to use as labels for your points; both are free, easy to install and use. If you want any particluar label, you can write a formula in a range of cells that concatenates the value and the label, then use this range for the labels. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com/ss - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Daniell wrote: On the Chart Options there is an option DATA LABELS. This option lets you print the following VALUE, PERCENT, LABEL and LABEL + PERCENT. Is there any way that you can print the Value and the Label. Or is there anyway you can modify any part of what you want to print beside the section of the pie chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing thwe width of data labels? | Charts and Charting in Excel | |||
"Bring to Front" Data Labels? | Charts and Charting in Excel | |||
Is there a way of attaching data labels from a text range to dat. | Charts and Charting in Excel | |||
VBA to change size of data labels? | Charts and Charting in Excel | |||
Using data as data labels | Excel Discussion (Misc queries) |