Default Chart Title Text & Text From Cell

[ruic1977]

Hi All,

I have created a macro to diplay a chart from some data but want the chart title to display as mixture of text entered in the Chart Title field of the wizard - i.e. 'Protection Shortfall Analysis' and also the name of a client in a cell (C8) within the worksheet.

So the chart title would read 'Protection Shortfall Analysis - Mr A Test'

Is this possible without having to enter code?

Thanks

Ruic1977

[ChemistB]

The Chart Title can be set to read a value from a specific cell (e.g. =A1) so if you put into A1

Please Login or Register  to view this content.

Then click on your Chart Title and in the formula bar type =A1.

That should do it. I don't know of any way to pull 'Protection Shortfall Analysis" directly from your wizard and add C8.

ChemistB

[ruic1977]

Thanks very much, that has done the job!

[ChemistB]

You're welcome