HOW TO PROGRAM EXCEL SO THAT THE TITLES ON GRAPHS ARE AUTOMATICALLY CHANGED

[Marcello do Guzman]

I am marketing a product that has lots of graphs. My problem is that
the user will have to change the titles in the graphs so that they
have their company name is in the graph. Is there anyway to automate
this using VBA? Is there something that I missed in EXCEL. I am using
XP. ANy help would be greatly appreciated.

SIncerely,


Marcello

respond. (e-mail address removed)

 

[Clark]

I am marketing a product that has lots of graphs. My problem is that
the user will have to change the titles in the graphs so that they
have their company name is in the graph. Is there anyway to automate
this using VBA? Is there something that I missed in EXCEL. I am using
XP. ANy help would be greatly appreciated.

Titles and textboxes may reference a cell. Build the title in a cell and all
the graphs can reflect the change.

VBA can address titles directly. Record a title change using the macro
recorder for a code example.

respond. (e-mail address removed)

You ask here, I respond here.

 

[Bill Li]

Hi Marcello
Following code can be used to change the tile of chart.

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartTitle.Select
Selection.Characters.Text = "Company Name"
ThisWorkbook.Activate

Best Regards

Bill