Custumize Chart Tittle Description
 

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

Custumize Chart Tittle Description
 

Click on the title, type =, and then click on D10 on Black.
Or click on the title, and type =Black!$D$10

--
Rob
Powered by Creative Laziness


"Maperalia" wrote:

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

Custumize Chart Tittle Description
 

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


"Rob Jordan" wrote:

Click on the title, type =, and then click on D10 on Black.
Or click on the title, and type =Black!$D$10

--
Rob
Powered by Creative Laziness


"Maperalia" wrote:

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

Custumize Chart Tittle Description
 

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/ex...010891033.aspx

-------
John Mansfield
http://www.cellmatrix.net


"Maperalia" wrote:

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


"Rob Jordan" wrote:

Click on the title, type =, and then click on D10 on Black.
Or click on the title, and type =Black!$D$10

--
Rob
Powered by Creative Laziness


"Maperalia" wrote:

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

Custumize Chart Tittle Description
 

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

"John Mansfield" wrote:

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/ex...010891033.aspx

-------
John Mansfield
http://www.cellmatrix.net


"Maperalia" wrote:

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


"Rob Jordan" wrote:

Click on the title, type =, and then click on D10 on Black.
Or click on the title, and type =Black!$D$10

--
Rob
Powered by Creative Laziness


"Maperalia" wrote:

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