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

M

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. [email protected]
 
C

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.
Click to expand...
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. [email protected]
Click to expand...
You ask here, I respond here.
 
B

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
 
Top