Hi Catherine,

I like your idea of having one text box saying YTD Referral = 25. I tried
it
using

="YTD Referral ="&Referrals!$N$2

I get an error message. Do you know why? How can I get text withing a
formula?

You have found one of the limitations of Charts in Excel.

Get around it by putting the formula ="YTD Referral ="&Referrals!$N$2 in a
cell on your sheet
and link the text box to that new cell.

Ed Ferrero
www.edferrero.com