If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|