Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to make chart title dynamic. Let’s get started
In the caption below, we have a sample data
For this example, we will create a clustered column chart. Dynamic Chart Titles works on all charts.
- In the Charts group of the Insert tab, click on Column Chart
The title we want to reference is located in cell A1 which is Total Sales By Account Manager
- Single-click on the default chart title.
- Click inside the formula bar
- Click on cell A1 and execute Enter
The chart title is dynamic. If the value in cell A1 changes, it will automatically update on the chart
To watch the video, see below