Dynamic Chart Title by Linking and Reference to a Cell in Excel

Home/Excel/Dynamic Chart Title by Linking and Reference to a Cell in Excel

Yes, we can make Dynamic Chart Title by Linking and Reference to a Cell in Excel. This very useful when you want to change your chart title automatically when there is any change in data. Or else you can simply change the title in Cell or Range in the worksheet. You can link the Cell Reference or Range Address to chart title. Here is the simple practical example to show you how to link cell of worksheet to Chart title. We can also change the chart title based on the condition or formula by linking a Cell to the Chart. Even we can link a pivot table filter range to the chart title.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Business Presentations Templates Pack
PowerPoint Slides

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


Dynamic Chart Title by Linking and Reference to a Cell in Excel – Practical Example

The following step by step approach is to show you example on Dynamic Chart Title by Linking and Reference to a Cell in Excel.

Linking Cell to make Dynamic Chart Title – Step 1: Select a Chart Title

Identify the chart to link a cell reference to the chart title. The following screen-shot will show you example chart title is selected.

Dynamic chart title- Cell linking to chart title

Dynamic chart title- Cell linking to chart title

Here you can clearly observe that there is no formula is associated to chart title. You can observe that the address bar is empty.

Linking Cell to make Dynamic Chart Title – Step 2: Enter Cell Reference using Address bar

Go to the Address bar and type “=” and select a Cell to link. In the following example, we are linking the Cell D2.

Dynamic chart title- Entering Cell Reference

Dynamic chart title- Entering Cell Reference

Linking Cell to make Dynamic Chart Title – Step 3: Press Enter button to see the title

Once you are done with the linking, press the ‘Enter’ key to link the chart title to the Cell. Now you should able to see the chart title as specified in the Cell or Range D2 in the worksheet. This is the easiest approach to create Dynamic Chart Title by Linking and Reference to a Cell in Excel.

Dynamic chart title- Entering Cell Reference to chart title

Dynamic chart title- Entering Cell Reference to chart title

Changing the Chart title based on the Conditions

The following example will show you how to change the chart title based on the condition. We will take the same data shown above and see how we can change the title based on the condition.

Changing the Chart title based on the Conditions – Step 1:Link a Cell to the Chart Title

Link the Cell to the chart title as shown in the above procedure.

Changing the Chart title based on the Conditions – Step 2:Now enter a condition in the linked Cell

Enter any condition in the Linked Cell, now you should see the Chart title is changing as per the condition. The following screen-shot will show you how to do this.

Chart title based on condition

Chart title based on condition

Now you can see the conditional formula in the linked Cell which is reflecting in the Chart title.

Changing the Chart title based on Pivot Table Filtered Cell

Same like above you can link a Pivot table filtered field cell to the chart title. Chart will change dynamically when you change filter of the pivot table. The following screen-shot will show you how to link a pivot table filter header to a chart title.

Dynamic chart title- based on pivot table filter cell

Dynamic chart title- based on pivot table filter cell

Her you can clearly observe that, chart title is linked to to the pivot table filtered cell. We have highlighted in the Yellow (G2), showing 2006 in the filter. You can see the same pivot table filtered value (2006) is showing as a chart title.

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template
LIMITED TIME OFFER - Get it Now!
Business PowerPoint Presentations Templates Pack
 
 
Related Resource External VBA Reference
By |April 20th, 2014|Excel|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment