Making Chart Titles equal Cell Contents

**JohnGuts** · 04-08-2007, 04:02 PM

Is it possible to have the title on a column chart change with the cotents of a specific cell? I would like to have the chart automatically change the title of the chart when the user changes the value of a given cell. Thanks for any help.

**duane** · 04-08-2007, 07:23 PM

sure - something like the following which assumes you put the desired title in cell a1 of activesheet and sheets "mychart" is the chart in question

Title = Range("A1").Text
Sheets("Mychartl").Select
    ActiveChart.ChartTitle.Select
    Selection.Characters.Text = Title

**JohnGuts** · 04-08-2007, 08:05 PM

Thanks for the reply. Where would I place this code?

**duane** · 04-08-2007, 08:24 PM

create a macro............tools, macro, etc

**alexwangsa** · 04-27-2007, 03:01 AM

Another way to name it is by creating the Title first. After that click on the title then in the formula bar write the formula such as "=A3". The graph title would be the same as the content in cell A3.

Making Chart Titles equal Cell Contents

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Making Chart Titles equal Cell Contents

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions