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

C

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

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
 

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

Move Chart with Text 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Excel does not accept text format! 0
Possible to Combine reports to's to a single box? 0
Paste to excel from word - auto format problem 1
One extra x axis item that wont go away - can anyone help? 3
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Word OLE to check spelling in text box 1

Top