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

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.

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

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