TExcelFile.AddChartSheet Method
Adds a chart sheet to the file. You can then add series and customize the returned ExcelChart object. Note that as this is a chart sheet, the anchor is ignored. The ActiveSheet after adding the chart will be set to the newly inserted chart.
Important: This method only works in xlsx files.
Syntax
Unit: FlexCel.Core
function TExcelFile.AddChartSheet(const insertBefore: Integer; const chartType: TChartType; const aChartStyle: TChartStyle; const roundedCorners: Boolean; const print: Boolean; const isLocked: Boolean): IExcelChart; virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | insertBefore | Integer | The sheet before which we will insert (1 based). This might be SheetCount + 1, to insert at the end of the Workbook. |
| const | chartType | TChartType | Kind of chart created. Note that you can have more than one type of chart in the same chart, so this just sets the base chart type. You can add other chart types over it. |
| const | aChartStyle | TChartStyle | Theme of the chart. This is a number between 1 and 48 which defines many standard properties for the chart, like the default line width for the series or the legend. The default style is 2. |
| const | roundedCorners | Boolean | If true, the chart will have rounded corners. |
| const | Boolean | True if the chart should be printed. | |
| const | isLocked | Boolean | True if the chart is locked. |