Class
ExcelChartGridLayout
OfficeIMO.Excel
Produces sequential chart placements for worksheet dashboards that use the default Excel row and column grid.
Inheritance
- object
- ExcelChartGridLayout
Usage
Explore 1 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 1
- Method ExcelSheet.ChartLayout
Constructors
public ExcelChartGridLayout(int row, int column, OfficeLength? width = null, OfficeLength? height = null, int chartsPerRow = 2, OfficeLength? horizontalGap = null, int verticalGapRows = 2) #Initializes a chart grid layout.
Parameters
- row int
- One-based worksheet row for the first chart.
- column int
- One-based worksheet column for the first chart.
- width OfficeIMO.OfficeLength? = null
- Chart physical width.
- height OfficeIMO.OfficeLength? = null
- Chart physical height.
- chartsPerRow int = 2
- Number of charts to place before wrapping to the next row.
- horizontalGap OfficeIMO.OfficeLength? = null
- Minimum horizontal physical gap between chart slots, calculated against default-width Excel columns.
- verticalGapRows int = 2
- Minimum vertical gap between chart rows, in worksheet rows, calculated against default-height Excel rows.
Methods
public ExcelChartPlacement Next() #Gets the next chart placement and advances the layout cursor.