Out Of This World Excel Plot Title From Cell

Thanks works perfectly - I notice that you can only refer to a cell.

Excel plot title from cell. Dynamic chart title- Entering Cell Reference Linking Cell to make Dynamic Chart Title Step 3. Now right click on the scatter. Steps to Create Dynamic Chart Title in Excel.

This video explains how to link your chart title to a cell in your Excel worksheet. In Excel 2013 click Design Add Chart Element Chart Title and select the location you need the chart title show such as Above Chart. Select the chart title enter an equal mark into the Formula Bar then click to select the cell containing the combined cell link and text and then press the Enter key.

Select chart title in your chart. If the values in the data range were to change our data labels and chart title would update to reflect that on the chart. Go to the formula bar and type.

First right-click anywhere inside cell A1 the first cell at the top left of your spreadsheet and choose Insert Select Entire Row and click OK to add a row of free space. You can hide the column that this is occurring in to make it invisible to the user. On the Format tab in the Current Selection group click the arrow next to the Chart Elements box and then click the chart element that you want to use.

Id like the series name to be a string concatenated with a fixed string. The value from cell E2 is used for the chart title. Now select Scatter Chart.

Click the chart title enter into the Formula Bar and then click cell E2. From Axis Title options choose the desired. Click anywhere within your Excel chart then click the Chart Elements button and check the Axis Titles box.