Sharon,

I'm speculating but I think the problem might be due to multiple sheet
references. Try adding a cell reference on the sheet with the embedded chart
that refers to the named reference. For example, if your chart is on Sheet 1
and you want your dynamic title to refer to the named reference called FAC,
in Sheet1!A1 add the formula =FAC. Then, change your dynamic title formula
to read =$A$1.

----
Regards,
John Mansfield
http://www.pdbook.com


"Sharon" wrote:

Hello,

I am having a problem with a dynamic chart title and saving, closing and
then re-opening the workbook and the chart title still being dynamic.

On Sheet2 of my workbook I have some drop-down menus in cells B2:E2.

On Sheet7 of my workbook in cells BA1:BA3 I have Concatenation formulas that
I want to use as my Chart titles.
For example: =CONCATENATE("This is my " Sheet2!$B$2, " ", "chart.")

I named the ranges on Sheet7, BA1 is named "FAC", BA2 is named "POD" and BA3
is named "NAF".

I then added a text box to my first chart where the chart title should go.
In the text box I put the formula =FAC.

Then I go back to Sheet2 change my options in my drop down menus, come back
to Sheet7 to make sure it worked and it does.

But, when I save the workbook, close it and re-open it, the text box seems
to "forget" the range that I had put in there and I have to do it all over
again.

How do I make the text box "remember" from save to save and open - close -
re-open?

This is the web site I used as a guide to accomplish this:
http://www.tushar-mehta.com/excel/ne...rts/index.html

TIA,

Sharon