I can individually reference a cell as a data point label, but how can I
reference a series of cells for teh whole series of data points? I don't want
to have to individually link data points to single cells. When I allow data
labels and try to enter teh formula reference in the formula bar, I am unable
to - I can only edit when I am referencing a single data point on the chart
--
Mardi

Hi,

Try Rob Bovey's free addin.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mardi" wrote in message
...
I can individually reference a cell as a data point label, but how can I
reference a series of cells for teh whole series of data points? I don't
want
to have to individually link data points to single cells. When I allow
data
labels and try to enter teh formula reference in the formula bar, I am
unable
to - I can only edit when I am referencing a single data point on the
chart
--
Mardi