Link a cell to chart title Actually, to link a cell to the chart title is very easy, please do as steps 1 Click at the chart to enable Chart Tools in the ribbon, then click Layout > Chart Title, and select the location you need the chart title show, such as Above Chart This does not work Excel expects to see a reference to a single cell or range of cells and not a normal formula The normal way to handle this is to set the formula for the 'Series Name' in a cell, and then set the Series Name equal to this single cell Formula in C2 =E2&" Test Results" Chart and data series ranges showing that the Series Name is equal to a single cell C2If I create a column chart with the default options, we get a chart with three data series, one for each year In this chart, data series come from columns, and each column contains 4 values, one for each product Notice that Excel has used the column headers to name each data series, and that these names correspond to items you see listed in
How To Create A Visualization Showing Normal Range Overlaid On Sample Metrics In Excel By Usman Raza Towards Data Science
