Dynamic Chart Title

[Cranford803]

I have a spreadsheet set up with a graph and a bunch of data below. Depending on the situation, I have it set so i can select the data source and it will automatically pull the data I need into that excel sheet, and the cart will graph it. The only problem is that when I change the source of the data, I also need the chart title or header to change with it for printing. How can I achieve this?

Thanks in advance for all of your input!

 

[rdw72777]

You can just link the chart title to the value you want to display. You can set up a cell hidden behind the chart that has the value you want in the chart title and just link the chart title to that.

Note, you'll need to click on the chart title box and select it as a whole, then click in the formula bar and then type in the address or click on a cell to link it. Its slightly finnicky.