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

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.

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

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


-----Original Message-----
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.
.