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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One extra x axis item that wont go away - can anyone help? 3
Displaying content of a cell somewhere on the chart 1
Loss of referenced data (Titles) when upgrading from Excel 2000 to2007 1
Surpressing plot of blank cells 3
Export to image ... way to get just cells without chart background? 3
VBA set thick borders around non empty cells in range 0
Incorporating Text Box in Excel Chart 4
How do I put a formula in a dialogue box; to be placed on a chart 1

Back
Top