linked Excel Chart distorted in Acc07

[Wolow]

Hi,
I have an excel 07 chart dynamically linked to an form-OLE field. This used to work smoothly in earlier access vesions.
Now, the chart shows somehow distorted, as if it has been stretched.
I do use SizeMode = acOLESizeClip
If you compare the original excel chart with thelinked one, the linked (in Access) chart has thick lines and generally look clumbsy, as if an additional bad rendering had been done. The size of the chart itself is identical, the labels seem identical, jsut the lines are gross,see attached png. The lower section is the original, the upper the linked.

scn!chart.Class = "Excel.Sheet" ' Set class name.
scn!chart.OLETypeAllowed = acOLELinked ' Specify type of object.
scn!chart.SourceDoc = source_dir & "temp.xlsx" ' Specify source file.
scn!chart.SourceItem = "" ' Specify data to create link to.
scn!chart.locked = False
scn!chart.Enabled = True
scn!chart.SizeMode = acOLESizeClip
scn!chart.action = acOLECreateLink ' Create linked object.
scn!requery.SetFocus

Has anyone an idea how this can be corrected?

TIA

 

[boblarson]

Don't use

scn!chart.SizeMode = acOLESizeClip

use STRETCH instead of CLIP (Not sure what the constant would be - perhaps acOLESizeStretch)

 

[Wolow]

Done that, doesnt change a thing

I used zoom, stretch, clip ... you name it.

but thanks

 

[boblarson]

I've never been fond of the reporting available in Access. I would much rather use Crystal Reports (especially if doing any charting) than using the Access Reports.