Text box that contains a range of cells not just one.

[Chili Don]

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]

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