How do I combine these two cells together in a text box of my graph chart? =Sheet1!$N$1 and =Sheet1!$N$100

[arthurz11]

I have inserted a text box into my graph chart. The formula is =Sheet1!$N$1. In this cell, it has the text "ADD" from worksheet 1. It works fine and the text is inserted into my text box of my graph chart. I also want to include cell $N$100 from worksheet1 and it has the text "DIMENSION". So in my graph chart, it should read "ADD DIMENSION" in the text box of my graph chart. So how do I combine =sheet1!$N$1 and =sheet1!$N$100 into the same text box of my graph chart?

 

[SpillerBD]

=Sheet1!$N$1 & " " & sheet1!$N$100

 

[arthurz11]

I copied your formula, but it didn't work. I tried that formula before. Anyway, I got an error. It read "This formula is missing a range reference or a defined name"

 

[geloader0]

=Sheet1.Range("$N$1 & " " & Sheet1!.Range("$N$100")