Help: Code; Graphs

[Walshie1987]

Hi I have a bar chart (MyGraph) and a button (MyButton) when I click "MyButton" I want "MyGraph" to change to a pie chart automatically, so i have entered the following code:

Sub MyButton_Click()
Dim GraphObj As Object

Set GraphObj = Me![MyGraph].Object.Application.Chart
GraphObj.Type = xL3DPie
End Sub

but get:

"Run-Time error '1004'

unable to set the type property of the chart class

any ideas?

 

[ck1999]

I made a quick chart in access 07 and your code seems to work for me.

ck1999

 

[TheAceMan1]

How are ya Walshie1987 . . .

You may need to refresh the object!

[blue]   GraphObj.Refresh[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Walshie1987]

Cheers for that, I'll play araound a bit

 

[Walshie1987]

Could some try the above code on Access 2003 please. Doesn't want to work for me at all!

Cheers

 

[skyline666]

Hi Walshie1987,

Im guessing you took that code from the below link:

http://support.microsoft.com/kb/210021

I think what you haven't done is step 9, where you have to add the reference for the graph object. Go to Tools->References on the Visual Basic Editor, and make sure that "Microsoft Graph 11.0 Object Library" is ticked (it says 9.0 on the link, but thats for Access 2000, whereas for Access 2003 which your, and me, using it is 11.0).

That should work, works for me anyway and I followed those steps on the link and it works perfectly.

Andrew

 

[skyline666]

I also just tried this on one of my own databases, so using a different table/query etc, and it works. Note that if you want to do something like this on a different database, you will have to tick the Graph 11 Object Library on that database aswell, in the same way I described above.

Andrew