How to Insert Chart Title from a Cell?

Inserting chart title from a cell in Excel can easily be done, and we are going to do it together.

Surprisingly, it would only take two simple steps. But first, have a look at this chart that we will insert a title into, from a cell:


Click on the chart title

click chart title

Click on the formula (1), type in =Sheet1$C$1 (2), and then enter.

click formula enter

Note: The sheet1 is the name of spreadsheet, while $C$1 is the cell we want to get title from.