Dynamic Titles In Graphs

Posted by Scott on August 15, 2001 2:47 AM

Is it possible to have dynamically titled graphs? By this I mean can the title of a graph be linked to a cell?

Thanks

Scott

Posted by Mark W. on August 15, 2001 6:44 AM

Yes. Select the title field, click on the formula
bar, type =, click on the cell containing the text
for your title, and press [ ENTER ].

Posted by jon on August 16, 2001 5:16 AM

A few days ago, I posted a question why the chart links remain open in Ecxel97 but are lost in Excel2000 after he file is closed. Noone has answered yet and a workaround has been to have an autoopen macro which reinserts the links.