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

  • Thread starter Thread starter Marcello do Guzman
  • Start date Start date
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. (e-mail address removed)
 
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. (e-mail address removed)
Click to expand...
You ask here, I respond here.
 
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
 
Back
Top