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
automatically update chart title
Posted by Aoife on December 04, 2001 4:15 AM
I have a chart which contains data that is updated monthly. it there any way of getting the chart title to refer to a cell on a worksheet so that it is automatically updated when the cell contents change. I am currently using a macro to do this which works, but there must be an easier way!
Re: automatically update chart title
Posted by lenze on December 04, 2001 6:53 AM
I don't believe it can be done using the Chart title option, but here is a work-around I've used. Instead of using the Chart Title option, insert a textbox from the drawing tool bar. Assign a name to the cell you want to reference such as "reference". Then, selected the textbox and then click in the formula bar. Enter =reference. This will link the textbox to the reference cell and will update the title whenever the reference changes. One point, this does not seem to work with charts based on Pivot tables. The textbox does not refresh automatically. With these you have to reselect the textbox and re-enter the =reference in the formula bar each time.
Re: automatically update chart title
Posted by Aoife on December 04, 2001 7:42 AM
it works perfectly, thanks Lenze
This will work with Chart Titles as well...
Posted by Mark W. on December 04, 2001 8:15 AM
Just select the Chart Title, activate the formula
bar and click on the cell containing the text
that you'd like to use as a title.
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.