| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I changed value scale numbers - goes back to what program wants? | Charts and Charting in Excel | |||
| hyperlinks changed automatically in excel. | Excel Discussion (Misc queries) | |||
| Excel graphs not updating when source data is changed | Charts and Charting in Excel | |||
| expanding titles on graphs | Charts and Charting in Excel | |||
| axes titles in excel graphs | Charts and Charting in Excel | |||
Linear Mode
