Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
I am using Excel 2007.
I have a title (with a date in it) in my worksheet and it is the same on a graph. For my report, I always change that date on the worksheet. how do I automatically change the title in the graph. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Hi Charles,
Click in the title on the chart and select (highlight) whatever is in there and then click up in the formula bar and enter = sign and then click in the cell containing the title that you want. -- Regards, OssieMac "Charles Eaves" wrote: I am using Excel 2007. I have a title (with a date in it) in my worksheet and it is the same on a graph. For my report, I always change that date on the worksheet. how do I automatically change the title in the graph. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Okay, but don't select the text of the title, or else the formula will be
shown as text, and there will not be a link. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "OssieMac" wrote in message ... Hi Charles, Click in the title on the chart and select (highlight) whatever is in there and then click up in the formula bar and enter = sign and then click in the cell containing the title that you want. -- Regards, OssieMac "Charles Eaves" wrote: I am using Excel 2007. I have a title (with a date in it) in my worksheet and it is the same on a graph. For my report, I always change that date on the worksheet. how do I automatically change the title in the graph. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Works for me Jon in both xl2002 and xl2007. However, your comment got me
testing without selecting the existing text; just ensure that the title box is selected. I now realize that I have been including an unnecessary step. Thanks for your input. I have learnt something again. -- Regards, OssieMac "Jon Peltier" wrote: Okay, but don't select the text of the title, or else the formula will be shown as text, and there will not be a link. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "OssieMac" wrote in message ... Hi Charles, Click in the title on the chart and select (highlight) whatever is in there and then click up in the formula bar and enter = sign and then click in the cell containing the title that you want. -- Regards, OssieMac "Charles Eaves" wrote: I am using Excel 2007. I have a title (with a date in it) in my worksheet and it is the same on a graph. For my report, I always change that date on the worksheet. how do I automatically change the title in the graph. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Oh, I see. When you click in the formula bar it unselects the text. I've
seen it the other way when someone selected the text and typed the formula in the highlighted title text rather than in the formula bar. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "OssieMac" wrote in message ... Works for me Jon in both xl2002 and xl2007. However, your comment got me testing without selecting the existing text; just ensure that the title box is selected. I now realize that I have been including an unnecessary step. Thanks for your input. I have learnt something again. -- Regards, OssieMac "Jon Peltier" wrote: Okay, but don't select the text of the title, or else the formula will be shown as text, and there will not be a link. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "OssieMac" wrote in message ... Hi Charles, Click in the title on the chart and select (highlight) whatever is in there and then click up in the formula bar and enter = sign and then click in the cell containing the title that you want. -- Regards, OssieMac "Charles Eaves" wrote: I am using Excel 2007. I have a title (with a date in it) in my worksheet and it is the same on a graph. For my report, I always change that date on the worksheet. how do I automatically change the title in the graph. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting? | Charts and Charting in Excel | |||
3D Charting | Charts and Charting in Excel | |||
charting add in | Charts and Charting in Excel | |||
charting in vb.net | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |