RESIZING OF DIAGRAM (Access 97 msgraph)

U

Udo Pecher

All I need is support in order to resize diagrams.

The aim is to change the size of a diagram on a form by VBA-Code.

Example:
'
dim obj as object
obj= Forms![F_GRAFIK]![testDiagramm]
'
with the new dimensions
obj.Height = 5500
obj.Width = 11000

These methods adust the frame of my diagram. But there is a problem with the
interior dimensions of the resized diagram. The interior dimension do not
change even when the frame is resizing. I.e. standard resizing methods do
not act on PlotArea.height, PlotArea.width, ChartArea.height,
ChartArea.width.

Therefore it is necessary to write the dimensions of the PlotArea
obj.PlotArea.Height
obj.PlotArea.Width

but note that obj.PlotArea.Height and obj.PlotArea.Width are limited by
obj.Chart.Area.Height and obj.Chart.Area.Width. E.g. obj.PlotArea.height <
obj.Chart.Area.height is always valid.

Consequently my main question: is it possible to change
obj.Chart.Area.Height and obj.Chart.Area.Width by special VBA Code. I didn't
succeed to write them. Standard resizing methods act on the diagram frame
only. Does a method exist to size the Chart.Area-dimensions by VBA code? My
aim is to resize a form and the integrated diagram in that way that the
diagramm fullfills the form completely.

Finally I do not know the units of the scale of a diagram. E.g.
obj.Height = 5500
obj.Width = 11000
why are the dimension numbers such high? Have 11000 and 5500 something to do
with the screen resolution (1024 x 768 e.g.)?


thank you very much for your support, Udo
 
Top