I have a range name that changes and I want to apply this name to the Title above my chart. I would like to use a formula like: =Region?
Thanks in advance
I have a range name that changes and I want to apply this name to the Title above my chart. I would like to use a formula like: =Region?
Thanks in advance
Did you try to add quotes around the named range
ie.
="Region"
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
Yes, but that does not work?
You need to add this to the "formula" bar after you click on the title area
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I inserted a text box, clicked inside the chart to create an empty text box. I then typed the equal sign in the formula bar and clicked the cell that contained the named range. This works.
glad you got it figured out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks