Chart manipulation in VBA (1 Viewer)

[tjrobert82]

Anyone have any idea what the line of code is that let's you change either an axis title or the chart title in a pre-made chart?

I have a form which has a chart made from Insert/Chart without any kind of coding...I have a button on that form and I would like it to change the properties of the chart (such as the title) when I click it. Looking at previous posts, I have seen the minimum and maximum scale manipulated using:

Me.Graph1.Object.Application.Chart.Axes(2).MinimumScale = 15
Me.Graph1.Object.Application.Chart.Axes(1).MinimumScale = 0
(same goes for maximum)

I can't figure out what the syntax is to change the title or an axis label. Every time I try something I get the error message "Object doesn't support this method or property." Any suggestions?

 

[SforSoftware]

maybe this document could help you?
http://msdn.microsoft.com/library/d...y/en-us/dnoffpro01/html/OfftheChartAccess.asp

 

[tjrobert82]

thanks

Good article. Explained lots. Thanks.