Shape adjustments - how to calculate adjustment for trapezoid

[Carl]

I am having problems getting correct adjustments figure for a trapezoid. In
Excel 2003 it was in a range of 0 to 0.5 with 0.5 effectively giving a
triangle.

In Excel 2007 this figure now seems depend on the height and width as well
(ie if you have a short wide shape the figure to get half way accross is much
higher).

I have not been able to discern how this is calculated and need to do this
as I am creating a diagram with several of these used which need to be
adjusted as a ratio from top to bottom (which worked easily in XL2003)

 

[Andy Pope]

Hi,

To form a triangle from the trapezoid the adjustment value is the ratio

1 / (Height/(Width/2))

I have an illustrative example which I will add to my site over the weekend.

Cheers
Andy

 

[Carl]

Hi,

To form a triangle from the trapezoid the adjustment value is the ratio

1 / (Height/(Width/2))

I have an illustrative example which I will add to my site over the weekend.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


Thanks Andy - does the job perfectly (even though means version specific code required which is a pain).

Is there any documentation by microsoft on what the adjustments are for the
various shapes and how calculated - this seems to be poorly (or obscurely)
documented.

Carl.

 

[Andy Pope]

Looks to be as good as it gets.
http://msdn.microsoft.com/en-us/library/aa661957(office.10).aspx

Cheers
Andy

 

[Andy Pope]

Page added to website
http://www.andypope.info/tips/tip013.htm