 | Evaluate Function - … on Evaluate Function |
 | dougaj4 on Drawing in Excel-3 |
 | DanF on Drawing in Excel-3 |
| Drawing in Excel-3 … on Drawing in Excel - 2 |
| dougaj4 on Elegant proofs 2 - The area of… |
This is a the first of a series of posts describing how to produce scale drawings in Excel, based on a list of coordinates. This post will cover the use of XY graphs, or scatter charts as Microsoft likes to call them. Later posts will cover the use of the various line and shape objects, [...]
Filed under: Charts, Excel | Tagged: Charts, Excel, line drawing, scale | 2 Comments »
The technique for calculating section properties from coordinates is conveniently coded into a UDF:
Function Area(xy_range As Variant) As Double
Dim XYcells As Variant
Dim N As Long, NumX As Long
Dim XD As Double, YSum As Double
XYcells = GetArray(xy_range)
NumX = UBound(XYcells, 1) - LBound(XYcells, 1) + 1
If NumX < 3 Then
 XYcells = Transpose1(XYcells)
NumX = UBound(XYcells, 1) - LBound(XYcells, [...]
Filed under: Arrays, Charts, Excel, UDFs | Tagged: Section Properties; Area; First Moment of Area; Second | No Comments »
