Dynamic Chart Title


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

Sample Data

In the caption below, we have a sample data

Create Chart

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

Posted in Blog and tagged .

Leave a Reply

Your email address will not be published. Required fields are marked *