Dynamic Chart Title

[thong]

Hello Gurus,

I am making 1600 graphs and I need your help to make my life a bit easier. I want to make a dynamic chart title.

I want that If I enter my column header my chart title will automatically change.

Please see attached file for your reference.

Thank you so much.

thong

 

[Luke M]

Build the string you want to display in a cell(s) somewhere. Then, select the chart title, go to formula bar. Type an "=" symbol, and click on the cell you built the title. Chart title will update to whatever is in the cell. Assuming cell has a formula, it will not be dynamic.

 

[thong]

Hi Luke,

Thank you for the reply. How can I extract the text of Column B33 up to 60mg only and C33 up to ER Tablets.

Please find attached file.

Thanks.

 

[Nebu]

Hi:

Use the following formula in an adjacent cell and copy across...
=LEFT(B33,SEARCH("Lot#",B33)-1)

Thanks