Excel graph title update automatically

  boo_hiss_boo 19:52 22 Feb 2005


can anyone help with an excel problem. I run graphs from a pivot table to give various combinations quickly. One table, one sheet, lots of graphs from changing the pivot table... however each time I change the graph, I have to manually change the title of the graph before I can print. Does anyone know how I can link the title of the graph to the pivot headers so that as change the pivot, the graph & title change all automatically?


  VoG II 20:54 22 Feb 2005

Yes, you should be able to change the title to


or wherever the title is.

  boo_hiss_boo 21:05 22 Feb 2005


When entering a chart title I can't enter formulas and therefore cant link to a changing cell (this was initially how I wanted to work it) but with a graph you add a fixed chart title and it won't accept links or formulas


  VoG II 21:19 22 Feb 2005

Just tested in Excel 2003.

Chart, Chart Options, in the title box entered


and it changes the title. You can do the same by clicking on the title, deleting everything and entering


where cell is the address where the title is.

  boo_hiss_boo 21:27 22 Feb 2005


I just tried the same and all it gives me is '=sales!b2' as my title. I am using office 2000 but also have tried in office xp at work.

Thanks Boo

  VoG II 21:28 22 Feb 2005

Remove the '


  boo_hiss_boo 22:09 22 Feb 2005


its not in the worksheet, I just added that here to show you what I had entered... soryy


  VoG II 22:12 22 Feb 2005

Click my yellow envelope. I'll send you by return a workbook (with state secrets, please keep to yourself).

  VoG II 22:54 22 Feb 2005

Sorry, you may need a bit of VBA to do this:

Sub boo()

ActiveChart.ChartTitle.Text = Sheets("ni").Range("b1").Value

End Sub

Press ALT + F111 to open the Visual Basic Editor. Then paste in the above but with what you want as the title.

Exit VBE, Tools/Macro/Macro, select Boo and click the Run button.

  VoG II 22:55 22 Feb 2005

That should be F11

  boo_hiss_boo 23:07 22 Feb 2005


sorry to be bugging you on this one. I tried the above and changed to

ActiveChart.ChartTitle.Text = sheets ("sales").Range("b1").Value

and I got the debug message

object variable or with block variable not set


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?