This way may be slightly less troublesome, although it costs an extra mouse click:

Select the text element (data label, chart title, axis title), click in the Formula
Bar, type the equals key, then click on the cell with the label you want to display.

To select a single data label, first, make sure the series has data labels, click on
a label to select the series of labels, then click on the label you want to apply
text from a cell.

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

rgraham1 wrote:
Jon,

Thanks for the heads-up on the Apple/Windows question. I guess trial and
error will be the best "instructor" on that issue.

On the issue of getting text from cells into the pie-charts, I had limited
success. I could get the Chart "title" pasted in okay, but I don't seem to
be able to get the "labels" from a cell into the pie-chart.


To get a text element in a chart to reflect the contents of a cell, select that
element (but do not activate text editing in that element), press the equals key,
and click on the cell with the label.


Am I asking more than Excel is capable of doing?

I haven't yet downloaded the shareware utilities you mentioned. I'll work
on that while I'm waiting to hear your response on the above.

Many thanks for your time and help. It has saved me quite a bit of time so
far.

This List is fortunate to have you,

Ron