How to link a cell to chart title/text box in Excel?

Inserting a chart to show the data vividly is usually used in Excel, and giving the chart a chart name can let users quickly and obviously know what is the chart about. And sometimes, you may want to link a cell to the chart title which can automatically change the chart title as the cell contents change. Here this tutorial will tell you the method to link a cell to the chart title.

Link a cell to chart title

Link a cell to chart title

Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!

Save 50% of your time, and reduce thousands of mouse clicks for you every day!

Actually, to link a cell to the chart title is very easy, please do as steps.

1. Click at the chart to enable Chart Tools in the ribbon, then click Layout > Chart Title, and select the location you need the chart title show, such as Above Chart. See screenshot:

In Excel 2013, click Design > Add Chart Element > Chart Title, and select the location you need the chart title show, such as Above Chart.

2. Then you can see a textbox appear in the chart, click Format tab, and select Chart Title from the drop down list in the Current Selection group. See screenshot:

Note: You can also click to select the chart title in the Chart directly.

3. Go to the formula bar, and type the equal sign = into the formula bar, then select the cell you want to link to the chart title. See screenshot:

4. Press Enter key. Then you can see the selected cell is linked to chart title.

Now when the cell A1 changes its contents, the chart title will automatically change.

Tip: If you want to link a cell to a text box, you just need to select the text box, and then type equal sign = in the formula bar, then select a cell to link. See screenshots:

Excel Productivity Tools

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for you.

• Designed for 1500+ work scenarios, helps you solve 80% Excel problems.
• Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
• Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
• Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
• 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
• Being used by 110,000 elites and 300+ well-known companies.

Read More Download Now Purchase

---

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

• Increases your productivity by 50% when viewing and editing multiple documents.
• Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
• Open and create documents in new tabs of same window, rather than in new windows.
• One second to switch between dozens of open documents!

Read More Download Now Purchase