G
Guest
Is there a way to add more information to a pie chart data label other than
manually edit, as this disables the link to source aspect.
manually edit, as this disables the link to source aspect.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Yes,
You might want to check out these resources:
John Walkenbach's Chart Labeler:
http://www.j-walk.com/ss/excel/files/charttools.htm
Rob Bobey's Chart Labeler:
http://www.appspro.com/Utilities/ChartLabeler.htm
A VBA routine to add custom labels:
http://www.pdbook.com/index.php/excel/add_text_range_as_chart_labels/
Finally, you can select the individual data label by clicking on it until it
looks like there is a box around it. Go to the Standard Toolbar and hit
Format -> Selected Data Labels -> Number Tab -> Custom option. Enter
something like "this label = 5" in quotations. This will custom format the
individual label.
You might want to check out these resources:
John Walkenbach's Chart Labeler:
http://www.j-walk.com/ss/excel/files/charttools.htm
Rob Bobey's Chart Labeler:
http://www.appspro.com/Utilities/ChartLabeler.htm
A VBA routine to add custom labels:
http://www.pdbook.com/index.php/excel/add_text_range_as_chart_labels/
Finally, you can select the individual data label by clicking on it until it
looks like there is a box around it. Go to the Standard Toolbar and hit
Format -> Selected Data Labels -> Number Tab -> Custom option. Enter
something like "this label = 5" in quotations. This will custom format the
individual label.
G
Guest
Thanks for the info.
I did try the edit labels but when the data is changed the chart label does
not reflect change.
Out of interest, as I share my charts etc. would charttools have to be
loaded to all pc's?
I did try the edit labels but when the data is changed the chart label does
not reflect change.
Out of interest, as I share my charts etc. would charttools have to be
loaded to all pc's?
G
Guest
Forgot to add, you can also click inside of the individual data label and
then add a reference to a cell. For example, you can click inside of the
data label and add a reference like this to the formula bar:
=Sheet1!$A$3
Whatever you enter into cell A3 will be reflected in the data label.
then add a reference to a cell. For example, you can click inside of the
data label and add a reference like this to the formula bar:
=Sheet1!$A$3
Whatever you enter into cell A3 will be reflected in the data label.
G
Guest
No, the chart tool add-ins only have to be installed on the machine in which
you are working to add the labels. I forgot to add another way to customize
data labels . . .
You can also click inside of the individual data label and
then add a reference to a cell. For example, you can click inside of the
data label and add a reference like this to the formula bar:
=Sheet1!$A$3
Whatever you enter into cell A3 will be reflected in the data label.
This method will allow the data labels to be tied to a cell. The label will
update when the cell value is changed.
you are working to add the labels. I forgot to add another way to customize
data labels . . .
You can also click inside of the individual data label and
then add a reference to a cell. For example, you can click inside of the
data label and add a reference like this to the formula bar:
=Sheet1!$A$3
Whatever you enter into cell A3 will be reflected in the data label.
This method will allow the data labels to be tied to a cell. The label will
update when the cell value is changed.