Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
Hi All,
When I try to use the code below to change some chart properties I get various error like " "Object doesn't support this method or property" (for the Refresh method) or the one which I can't recall at this moment but basically says that the property can't be changed (regarding the ChartTitle.Text property) Sheet_6.ChartObjects(1).Visible = True Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five Years of Analysis" Sheet_6.ChartObjects(1).Refresh Are these valid statements? Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating DOS from VBA | Excel Programming | |||
manipulating pictures with VBA | Excel Programming | |||
Manipulating Excel pie charts with VB | Excel Programming | |||
Manipulating Excel pie charts with VB | Excel Programming | |||
Manipulating Excel pie charts with VB | Excel Programming |