Variable labelling of charts

[nigelandrewfoster]

Simple question.
I have a macro which fills a table with dates in column 1 and invoice totals in invoice 2 of a customer I select. It works fine, but want the title of the chart to reflect the value of cell A4. How do I do this, please?
Thank you,
Nigel

 

[GlennUK]

Why don't you link the Chart Title with the cell?

 

[nigelandrewfoster]

That sounds like exactly what I need to do. How do you do that, then? Not very clue
d up on charts.

 

[GlennUK]

Insert a chart title, then with the chart title being the active object type "=" in the formula bar and navigate to the required cell, press Enter.