Linking a Worksheet Title to a Chart Title in Excel

 May 12, 2016

Automation is what technology is all about so if I can find ways to automate something, I will. Someone asked me recently whether you could link an Excel worksheet title to a chart title. “YES!” I said. I was glad they asked as I had forgotten that it was possible until they asked.

It’s a very easy process:

  1. Select the Chart Title
  2. Click into the Formula Bar
  3. Type and equal sign
  4. Click in the cell you wish to link to
  5. Press Enter

That’s it! Couldn’t be easier. Now, if your title changes, the chart title does too!

How do your Excel skills stack up?   

Test Now  

About the Author:

Ben Kirk  

With over 16 years of experience working as a Desktop Applications specialist for a number of large education services providers, Ben is one of New Horizons most skilled and dynamic instructors. With his Advanced Diploma of Business Skills alongside his practical experience and expertise, Ben is able to provide insight and guidance to students at all skill levels across the entire Microsoft Office suite.

Read full bio
top
Back to top