Excel graph title update automatically

  boo_hiss_boo 19:52 22 Feb 2005
Locked

Hi

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?

Thanks
Boo

  VoG II 20:54 22 Feb 2005

Yes, you should be able to change the title to

=A1

or wherever the title is.

  boo_hiss_boo 21:05 22 Feb 2005

VOG

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

Boo

  VoG II 21:19 22 Feb 2005

Just tested in Excel 2003.

Chart, Chart Options, in the title box entered

=ni!b1

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

=cell

where cell is the address where the title is.

  boo_hiss_boo 21:27 22 Feb 2005

VOG

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 '

=sales!b2

  boo_hiss_boo 22:09 22 Feb 2005

VOG,

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

Boo

  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

VOG

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

Thanks
Boo

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

Elsewhere on IDG sites

Nokia 8 vs Galaxy S8

Best new design books 2017: From vintage infographics to the the psychology of type

iMac 21.5-inch (2017) review

Nokia 8 : design, caractéristiques techniques, date de sortie