Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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

Re: Dynamic Titles In Graphs

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 ].

Re: Dynamic Titles In Graphs

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.