Hi,

You can only link to one cell so you need to concatenate the cells in
another cell and then link to that.

Cheers
Andy

Chili Don wrote:
I am trying to create a text box in a chart that contains a range of cells.
I ahve seen this on a chart but cannot don't understand how it was done.
Every time I try I can only enter one cell.

--

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