A Chartsheet object represents a worksheet that contains only a chart. |
public sealed class Chartsheet : Worksheet |
Public NotInheritable Class Chartsheet Inherits Worksheet |
To create a Anchors behave slightly differently on Chartsheets than on regular worksheets. When creating an anchor, the row and column properties are ignored. The OffsetX and OffsetY properties specify a percentage value, with 0 corresponding to the left or top edge, and 100 corresponding to the bottom or right edge of the Chartsheet. This allows you to add a shape or picture to an arbitrary position on the Chartsheet. Similarly, the Width and Height properties on Shapes, Pictures, and Groups specify a percentage of the total width or height of the chartsheet. So a Shape with a width of 25 would occupy 25% of the Chartsheet. You can have as many Shape, Pictures, and Groups as you wish on the chartsheet. However, you may only have one chart on the chartsheet, which is specified with the Chart property. Some Worksheet properties are not valid on a Chartsheet.
|
|
Name | Description |
---|---|