For the Column (X axis) and Row (Y axis), the formula are
- X axis = (Index()-1)%Int(Sqrt(Size()))
- Y axis = Int((Index()-1)/Int(Sqrt(Size())))
Size() is related to the number of trellis cells. The formula are based on Sqrt(Size()) and will result in asymptomatically the same numbers of columns and rows, or a square-like trellis chart. This is not the only option though.
We can have quite different numbers of columns and rows, thus various sizes of trellis chart.
In theory, we can pick an arbitrary integer as the # of columns <= Size(). Then we use the following formula for X axis and Y axis:
- X axis = (Index()-1)%[# of columns]
- Y axis = Int((Index()-1)/[# of columns])
In the following example, we got a dimension Country Name having 36 countries. Assume we pick the # of columns to be 2, 3, 4, 5, 6. The corresponding # of rows will be 18, 12, 9, 8, 6. We thus got 5 options of trellis chart for the same data set.
Add a comment