VBA for chart title

[Philb1]

Hello.. I'm trying to get some text as well as a R1C1 for the chart title. I'm stuck on how to do it. I've tried & I've Googled but.
The R1C1 bit works on it's own. But when I try to add the text it either throws an error or the title stays blank on the chart

Any ideas please

Please Login or Register  to view this content.

Or something like that I would guess
Thanks

[arlu1201]

Do you need to do it via VBA? You can directly do it in excel. It will be good if you post a sample workbook and we can help you out faster.

[Andy Pope]

You can not do post things. You either link the chart title to a cell, which will display the contents of the cell. Or you set the text to be static based on the contents of the cell and some appended text.

Please Login or Register  to view this content.

The rc notation will only work is that is the setting being used.

[Philb1]

That would explain why I couldn't do it
Thanks Andy, you are a mine of information

Please Login or Register  to view this content.

In the cell did the trick
Cheers
Phil