Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing chart title via vba?
I don't understand why this is so difficult, but I'm trying to change
the title bar of a chart. I couldn't get the code to work, so I just recorded a simple macro to see a "working" version. Problem is, the recorded macro doesn't work either! Here's the code from the macro: Sub Macro1() Sheets("3. FHS").Select ActiveSheet.ChartObjects("ProjGraph1").Activate ActiveChart.ChartTitle.Select Selection.Characters.Text = "Text" End Sub When I press play from within the editor, I get: Run-time error '-2147221080 (800401a8)': Method'ChartTitle' of object'_Chart' failed This should be so simple, but as a newbie, I'm making no progress whatsoever .... b ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a chart title, but keep the title in the chart | Charts and Charting in Excel | |||
changing vbOKCancel button title | Excel Discussion (Misc queries) | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
Changing Graph Title W/ Pivot | Excel Discussion (Misc queries) | |||
changing chart title via vba? | Excel Programming |