Handling chart in VBA

[georgp]

Hello,

I have a form (called frmDose) which includes a subform (called frmDiagram1) with a chart (a x,y-diagram called Diagram1). I would like to modify details of this diagram with VBA, e.g. display the trendline equation in a separate textbox on the form (and not in the graph), or to adjust the x-values (not starting with 0 but with a certain value closer to the actual value range).
Any idea how I can programatically access these items of the diagram?

Any help is welcome.
Thanks, georgp

 

[georgp]

Hi,

forgot to say the form is a MS-Access form.

Thanks, georgp