Excel: Linking My Chart Title to a Cell

A year ago, I found an online hint about typing a name for a chart in a cell, then linking to it.  It only worked about half the time, and I could never figure out why. Today I finally solved the mystery of the linked chart title, and I want to share my discovery.

Excel Chart F2 buttonClick on the title of the chart.  Press the function key on your keyboard labeled “F2” or simply click your cursor on the Formula Bar.
This is the shortcut for editing any cell – now you are editing your chart title.  Your cursor will jump up to the Formula Bar.  Type = and click on your cell reference.  When you hit enter, your title will match your cell.
 Excel Chart Formula Bar cursor
Just in case you have a chart without a title, click on the edge of your chart.  The Chart Tools menu will appear.  In the Chart Layout section, select a layout with a title – the ones with a bluish box near the top.  You can click the down arrow to get more selections.
Excel Chart Layouts

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s