Microsoft Office Tutorials and References
In Depth Information
DETERMINE THE HEIGHT AND WIDTH OF THE DATALABEL OBJECT
Gotcha: Unlike pivot tables built from data in a worksheet, this pivot table does
not calculate until you drag one ﬁ eld to the data area. Don’t worry if you drag a
region to the row area and nothing happens. As soon as you add Revenue to
the data area, the pivot table calculates, and the regions ﬁ ll in.
Summary: You can create code that grabs similar data from multiple worksheets
and summarizes it in a pivot table.
This topic was nominated by Denis Wright (aka SydneyGeek), who builds
custom Excel and Access solutions in Sydney, Australia, and loves to solve
problems. Among other things, he maintains a website with Excel and Access
tutorials; see http://www.datawright.com.au.
DETERMINE THE HEIGHT AND WIDTH
OF THE DATALABEL OBJECT
Challenge: The DataLabel object does not have either a height or width
property, and Excel does not permit the user to resize a data label. In some
situations, you may need to determine these properties. A case in point is a
series with long, wrapping label text or labels of points that are very close to
each other, where it is intended to programmatically adjust label position to get
rid of any overlaps (Figure 85).
Figure 85. You want to i nd the height and width of the DataLabel
object for point 210, 414.