Units for width and height for charts to powerpoint

[vbanovice123]

Hi,

I am not sure what units the below numbers are in . Is it pixels? The chart properties are usually in inches. example : height is 3.47 and width is 5.3 inches.

But what is the corresponding units when we assign a number to the width and height in the vba code? Any help is appreciated.

Thanks!

' Resize:
sr.Width = awidth
sr.Height = aheight
sr.LockAspectRatio = lockaspect

If sr.Width > 500 Then
sr.Width = 500
End If
If sr.Height > 250 Then
sr.Height = 250
End If

 

[shg]

They are in points = 1/72 inch.

 

[vbanovice123]

The height works fine. 378 equals 5.25 inches. But the width gives me 8.01 for 636.48 .

I have to convert 8.84 inches to points.

Are you sure width is also in points?

I did 1 point = 1/72 inch.

Thanks