Manipulating Charts with VBA
Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five
Years of Analysis"
give an error unless you make hascharttitle = true
With Sheet_6.ChartObjects(1).Chart
.HasTitle = True
.ChartTitle.Text = "Total Costs during Five Years of Analysis"
End With
there is no refresh method for a chartobject. The chart is refreshed when a
calculate is performed.
--
Regards,
Tom Ogilvy
"Rick" wrote in message
news:zhkgc.160673$K91.413926@attbi_s02...
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
|