Excel Tie the Chart Title to a Cell

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Tie the Chart Title to a Cell

Problem: I want the chart title to be calculated on the fly.

Strategy: Build your formula in a cell on the worksheet. You can use any formula and concatenation to build a complete title.

Figure 1050 Build the text for your title in a formula.

Select the title in the chart. Make sure that it has a solid box around the title. If you have a dashed line around the title, you are in text edit mode. Click on the dashed line to make it a solid line.

Click in the formula bar. Type an equals sign. Click on the cell that contains your formula. The formula bar will show a formula that looks like it is pointing to another worksheet, =’Daily Plan’!$N$30. When you press enter, the words from the cell will appear in the title. You might need to adjust the font to make it fit.

SHARE

Additional Info

Spread the Word Excel

MrExcel.com & related websites debuted on November 21, 1998.

ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only,
without warranty either expressed or implied, including but not limited to the implied warranties of
merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures
on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon
or other sites is reinvested in keeping MrExcel.com and ExcelArticles.com running. You can earn a commission for
sales leads that you send to us by joining our affiliate program. View my Privacy Policy.

Excel ® is a registered trademark of the Microsoft Corporation.
MrExcel ® is a registered trademark of Tickling Keys, Inc.