Microsoft Office Tutorials and References
In Depth Information
21.13 The PageSetup Object
With ActiveChart.Legend.LegendEntries(1).LegendKey
.Interior.ColorIndex = 3
.Border.Weight = xlThick
End With
21.13 The PageSetup Object
The PageSetup object represents all of the page formatting for a chart (or worksheet). The
members of the PageSetup object are shown in Table 21-3 .
Table 21- . Members of the PageSet up object
Application
FitToPagesWide
PrintErrors<v10>
BlackAndWhite
FooterMargin
PrintGridlines
BottomMargin
HeaderMargin
PrintHeadings
CenterFooter
LeftFooter
PrintNotes
CenterFooterPicture<v10>
LeftFooterPicture<v10>
PrintQuality
CenterHeader
LeftHeader
PrintTitleColumns
CenterHeaderPicture<v10>
LeftHeaderPicture<v10>
PrintTitleRows
CenterHorizontally
LeftMargin
RightFooter
CenterVertically
Order
RightFooterPicture<v10>
ChartSize
Orientation
RightHeader
Creator
PaperSize
RightHeaderPicture<v10>
Draft
Parent
RightMargin
FirstPageNumber
PrintArea
TopMargin
FitToPagesTall
PrintComments
Zoom
For instance, the following code sets the margins and then does a print preview for the active chart:
With ActiveChart.PageSetup
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.75)
.TopMargin = Application.InchesToPoints(1.5)
.BottomMargin = Application.InchesToPoints(1)
.HeaderMargin = Application.InchesToPoints(0.5)
.FooterMargin = Application.InchesToPoints(0.5)
End With
ActiveChart.PrintPreview
21.14 The PlotArea Object
The plot area of a chart (see Figure 21-1 ) is the area where the chart data is plotted. For a 2-D
chart, it consists of the data markers, gridlines, data labels, trend lines, and optional chart items,
but not the axes. For a 3-D chart, it also includes the walls, floor, axes, axis titles, and tick-mark
labels in the chart. The plot area is surrounded by the chart area (which does contain the axes on a
2-D chart).
The PlotArea object has Border, ChartFillFormat, and Interior children used for the formatting of
these items. The PlotArea object also has Top, Left, Height, and Width properties that can be used
 
 
 
Search JabSto ::




Custom Search