data label reference change

Is there a way to change all data labels in regards to cell references
associated with a series at once, rather than selecting each data label one
at a time, entering = on formula bar and selecting the cell? Another words,
I want to select all data labels, then somehow asscoiate them with cell
references other than the series references.

Hi,

Not manually. Try this free add-in
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

dogween wrote:
> Is there a way to change all data labels in regards to cell references
> associated with a series at once, rather than selecting each data label one
> at a time, entering = on formula bar and selecting the cell? Another words,
> I want to select all data labels, then somehow asscoiate them with cell
> references other than the series references.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info