Programming a gauge

[ruthib4]

Hi,

I am trying to program a gauge type dashboard using vba with access, it is very basic but I am stuck when trying to modify a property of msgraph chart called "firstsliceangle" like this

Firstsliceable = xxxx

I am getting nothing, does anybody know how to do it?



Please

[June7]

What property are you modifying? Are firstsliceangle and firstsliceable declared variables?

[ruthib4]

I have created a chart using MS graph in a form in access, "firstsliceangle" property is modifiable when double clicking in a pie chart' series point and go to options, you will see that there is a property called First Slice Angle.

This property I need to change via VBA within an access vba rutine. I was told that I can do it just by|

With me.graph(0)
.firstsliceangle= myvariable
En d with

Did not work.

Please help

[June7]

Can you provide project for analysis so I don't have to build from scratch?

[ruthib4]

Sorry for the delay, attached you will find the project.
What you will see is just the formatted graph simulating a needle, when you double click in the chart you will be able to edit the properties and then change the first slice angle.

Any help would be much appreciated.

Thansk in advanceAttachment 5334

[June7]

First, need to set library reference in the VBA editor: Tools>References>Microsoft Graph 12.0 Object Library.

I used the AfterUpdate event of textbox instead of Change with this code:
With Me.Gráfico0.ChartGroups(1)
.firstsliceangle = Me.txtvalor
End With

I also set Validation in the textbox: <=360

The graph changes but not sure it is doing what you want.

This article gave me some help: http://www.itechtalk.com/thread1189.html

[ruthib4]

My Friend,

here's my project so far, it works really nice - I really appreciate your help

Thanks a lotAttachment 5358