Most folks create static chart titles using the “Chart Options” menu in Excel.
Excel has an easy trick to link the chart title to any cell, without using the “Chart Options” menu. How to:
- After the chart is created, use the cursor to click the title that you want to link
- In the formula bar type “=”
- Click on the cell that you want the title to link to (I linked to cell D1) the name of the worksheet is “pareto”
The title is linked. Anytime cell D1 changes, the title in the chart will update automatically. You can use the same methodology to link the x axis title and the y axis title to cells.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare