Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shape adjustments - how to calculate adjustment for trapezoid
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shape adjustments - how to calculate adjustment for trapezoid
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 "Carl" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shape adjustments - how to calculate adjustment for trapezoid
"Andy Pope" wrote: 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 "Carl" wrote in message ... 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) 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shape adjustments - how to calculate adjustment for trapezoid
Looks to be as good as it gets.
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Carl" wrote in message ... "Andy Pope" wrote: 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 "Carl" wrote in message ... 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) 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shape adjustments - how to calculate adjustment for trapezoid
Page added to website
http://www.andypope.info/tips/tip013.htm Andy Pope wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate quantity of shapes inside another shape | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Calculate,Copy, Paste Cell Group Macro Adjustments | Excel Programming | |||
Editing text in text box grouped within a trapezoid | Excel Programming | |||
HOW DO I CALCULATE SUFACE AREA DEPENDENT ON SHAPE | Excel Discussion (Misc queries) |