| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bubble Chart with text as description of an axis | Charts and Charting in Excel | |||
| chart description-font format | Charts and Charting in Excel | |||
| Help and description for UDFs | Excel Worksheet Functions | |||
| How do I sum based on a description for a pie chart | Charts and Charting in Excel | |||
| Description box in excel | Excel Discussion (Misc queries) | |||
Linear Mode
