how to cell reference a Chart title
 

I want to reference a cell for chart title so that excel gets it
automatically from a cell without typing in Title tab/Chart title box. I
tried to use indirect command but it didn't help also I search help for
charting in Excel help file but couldn't find anything. Is it possible?
TIA, Rasoul Khoshravan, Tabriz, Iran

See Dynamic Chart Title
http://www.tushar-mehta.com/excel/ne...tle/index.html

"Rasoul Khoshravan Azar" wrote:

I want to reference a cell for chart title so that excel gets it
automatically from a cell without typing in Title tab/Chart title box. I
tried to use indirect command but it didn't help also I search help for
charting in Excel help file but couldn't find anything. Is it possible?
TIA, Rasoul Khoshravan, Tabriz, Iran

Thanks for the reference.
I forgot to tell my Excel Ver.
I am using Excel 98. Is Dynamic Chart title works in Excel 98.
Also I couldn't understand what is -- key ?


"Tushar Mehta" wrote in message
...
See Dynamic Chart Title

http://www.tushar-mehta.com/excel/ne...tle/index.html

"Rasoul Khoshravan Azar" wrote:

I want to reference a cell for chart title so that excel gets it
automatically from a cell without typing in Title tab/Chart title box. I
tried to use indirect command but it didn't help also I search help for
charting in Excel help file but couldn't find anything. Is it possible?
TIA, Rasoul Khoshravan, Tabriz, Iran