Creating a chart with VBA

[PRodgers4284]

I have a macro that creates a chart automatically and i want to define a an additional range in the code, the range is "C1" and is for the title of the chart, can anyone help me add this to the code:

Please Login or Register  to view this content.

[Andy Pope]

can you not just replace the text with a range reference?

Please Login or Register  to view this content.