MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Titles in Charts


Posted by Chip on July 10, 2001 5:59 AM

I'm creating a bunch of charts using a combo box (created using the forms toolbar) and a couple of vlookups. This works great but I have to manually change the titles on the charts. Is there a way to link the titles to a list so that the chart title is automatically updated as well?

Thanks for any help!


Posted by Mark W. on July 10, 2001 6:21 AM

Yes...

1. Select the text in the Chart Title field
2. Activate the formula bar by clicking on it and
type an equal sign (=).
3. Finally, click on the worksheet cell containing
the text that you want to appear as the chart title.