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 C2 In this example, we are linking the title of our Excel pie chart to the merged cell A1 You can also select two or more cells, eg a couple of column headings, and the content of all selected cells will appear in the chart title Move the title within the chart This Excel Factor tip is from Dr Isaac Gottlieb, professor at Temple University in Philadelphia Words by Mynda Treacy Excel In Cell Charts aren't actually charts at all, insofar as you won't find them in the Charts menu in Excel They're actually a formula that you can insert in any empty cell, like you see in column C below
Chart Blocks Squarespace Help
