Adapt Formula Title For Free

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 the chart, and then click the Chart Design tab. 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.

Apply a cell styleSelect the cells that you want to format. For more information, see Select cells, ranges, rows, or columns on a worksheet.On the Home tab, in the Styles group, click the More dropdown arrow in the style gallery, and select the cell style that you want to apply.

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.

Use a HeaderClick the Insert tab.Click the Header & Footer button on the ribbon.Click into the text box and type the spreadsheet title.Click into cell A1, the first cell on the spreadsheet.Type the title for the spreadsheet.Highlight the text you just typed.More items...

To easily update a chart or axis title, label, or text box that you have added to a chart, you can link it to a worksheet cell. Changes that you make to the data in that worksheet cell will automatically appear in the chart.

The solution is quite simple - you need to link the chart title to a cell with a formula.Click on the chart title.Type the equal sign (=) in the Formula bar.Click on the cell that you want to link to the chart title.Press the Enter button.Jan 20, 2014