Use Formula Title For Free

Add a chart title Click Add Chart Element > Chart Title, and then click the title option that you want. Type the title in the Chart Title box. To format the title, select the text in the title box, and then on the Home tab, under Font, select the formatting that you want.

Drag a title to the location that you want In the chart, click the title that you want to move to another location. To move the title, position the pointer on the border of the title box so that it changes to a four-headed arrow. , and then drag the title box to the location that you want.

Note: The cell should have the text that you'd like to be your chart title (as cell B2 in the example below). The cell can also contain a formula. The formula result will become your chart title. You can use the formula directly in the title, but it is not convenient for further editing.

Link Excel Chart Title to Cell with Pivot Table Filter - YouTube YouTube Start of suggested clip End of suggested clip And maybe make it a little smaller. And now we would like to create a title for this chart. So itMoreAnd maybe make it a little smaller. And now we would like to create a title for this chart. So it explains what we're looking at to add the title. I'm going to the Excel ribbon.

You can't use formula in chart title, but you can link it with a cell having a formula. If you want to enter a line break in chart title you can create that line break in the cell you are linking to.

Click on the Chart Title box. Go to Formula bar and type = Select the cell that you want to show as the chart title. Hit Enter.

You can also add a new series to a chart by entering a new SERIES formula. Select the chart area of a chart, click in the Formula Bar (or not, Excel will assume you're typing a SERIES formula), and start typing.