The ampersand is used to join together bits of text.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
On May 12, 1:27 am, "Jon Peltier"
wrote:
Remove the legend. Put custom labels into a cell next to the data.
Suppose
your categories are in column A and the values in column B. Then in C1
enter
this formula

=IF(B1=0,"",A1&" ("&B1&")")

This makes C1 look blank unless there is a value in B1, then it gives you
a
label like "Mortgage (1500)". You can get fancier with the label, of
course.

Then use one of these free Excel utilities to apply the labels in column
C
to the data in your chart:

Rob Bovey's Chart Labeler,http://appspro.com
John Walkenbach's Chart Tools,http://j-walk.com

When a wedge isn't showing, its value is zero, so the data label doesn't
appear.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutionshttp://PeltierTech.com
_______
Thanks a lot for this, it is appreciated. I will work on this today.
What is the '&' for in the formula please. I am only just and so
getting into mre advanced formulas and not too sure on its relevance

T