Custumize Chart Tittle Description

[Maperalia]

How can I make the Chart Tittle to be equal to a specific cell located in one
sheet. For example, I have a description on the cell "D10" located in the
sheetname "Black" . I want this description to be the Chart Tittle because is
a number that will change in the daily basic.
I have been using this formula "=Black!D10"; however, is not working.

Thanks in advance.
Maperalia

 

[Maperalia]

Rob;
Thanks for your quick response, I copied the formula in the tittle and
nothing happened. After I typed it I got just the formula (=Black!$D$10 ).
Could you please tell me if I have missed something?
Thanks.
Maperalia

 

[John Mansfield]

When you type the "=" sign, make sure you type it in the formula bar. Then
make sure you enter both the sheet name and cell reference.

Here's a link to instructions from Microsoft:

http://office.microsoft.com/en-us/excel/HP052010891033.aspx

 

[Maperalia]

John;
Thanks very much. It is working!!!!!
Maperalia