Access 2013 Chart Diagram Modification with VBA

[Stefan Moser]

Dear all
I would like to do two things

1.) pink arrow // I've changed the titel in a diagram with vba ... is there also a methode to move the position of the titel with vba ( left-center or rigth ? )

Private Sub Form_Current()


' KostenHinweis im Diagram
Me!Dia_WS.Object.ChartTitle.Text = _
"Preis: " & Me.[Roh-Preis] & "€/kg " & _
" Mindestbestand =" & Round(Me.MindestBestand * Me.[Roh-Preis], 0) & "€ ; " & _
" Maximalbestand =" & Round(Me.MindestBestand_Max * Me.[Roh-Preis], 0) & "€"
'Me!Dia_WS.Object.ChartTitle.Left ???
End Sub

2.) red arrow // maybe its because of the titel placement but ...
I would like to change the size of a diagram with VBA code to have the diagram fit nicely to a given space
best thing would be if there would be a possibility to resize the diagram in the given space
// Thanks Stefan

[June7]

I've built code to manipulate graphs in Access but never tried to position title nor resize graph. How is the 'given space' determined?

I don't know why the title isn't automatically centered. Resizing a graph causes all kinds of issues - one of which is it affects font size.

This is one complicated chart. Never seen anything like this. I deal with graph issues best when I can work with data. If you want to provide db for analysis, follow instructions at bottom of my post.

[Stefan Moser]

Yes your right its best to work with data ...
unfortunately the data is calculated each time on demand so it's tricky to send data (because the related stuff is confidential and I really can’t ( Code of conduct ...)
à But it isn’t the diagram, that works perfect it's just because like you mentioned while playing with the size all kind of funny things happen to text size ,general appearance , scaling ...
Sometimes it’s not even possible to save and return back to normal draft view for diagram draft view …
So I was looking for a list of object and the way to manipulate those elements with VBA Code
Like you could easy find it for Excel Chart.GetChartElement Method (Excel ) but not for Access

[June7]

I don't have an all-encompassing reference for VBA to code graphs, just what I can mine from the web. Good luck hunting.