Cell referance(Value) in text box

[ducecoop]

Excel 2007

I have a graph (bar) on a seperate sheet from my data.
Data has been dumpted to Excel from Access
not all fields (cells) are wanted to be graphed
HOWEVER
2 fields (cells) need to be displayed on the graph in a text box Along with text.

So I need the text box on the graph to look like this

sits in ares = 3
where 3 is a value on worksheet "Data" and cell S3 (=Data!S3)

so how to I combine this text AND a cell reference into a text box.

Any help here will be appreciated.

Thanks in advance

dave

[martindwilson]

if its a standard text box linked cell say C1 put text in say D1 with required spaces
anD then in c1 put =D1& S3

[ducecoop]

if its a standard text box linked cell say C1 put text in say D1 with required spaces
anD then in c1 put =D1& S3

Thanks

dave