Dynamic Chart Title

[thong127]

Hi All,

Can you please share your expertise.

I want to make a Dynamic Chart Title Like the title shown on my attached graph using the info below my comment.

Thanks in advance to any help you can extend.

[Andy Pope]

If you select the chart title and then in the formula bar enter
=Bio!$A$51:$A$55

It will display the contents of A51:A55.

If you want to produce the same text as your example then build that text in a different cell and link the chart title to that

[thong127]

Thanks Andy