TXLSXChart 與 TXLSXCharts 類別

TXLSXChart 與 TXLSXCharts 類別

function TXLSXCharts.Add: TXLSXChart; overload;
function TXLSXCharts.Add(AChartType: TXLSXChartType; const ATitle: WideString; AFromRow, AFromCol, AToRow, AToCol: Integer): TXLSXChart; overload;
function TXLSXChart.AddSeries(const AName, ACategories, AValues: WideString): TXLSXChartSeries;
procedure TXLSXChart.ClearSeries;
property TXLSXChart.ChartType: TXLSXChartType;
property TXLSXChart.CategoryAxis, ValueAxis: TXLSXChartAxis;
property TXLSXChart.Series[Index: Integer]: TXLSXChartSeries;

TXLSXChart 與 TXLSXCharts 類別

主要成員

function TXLSXChartSeries.AddTrendline(AType: TXLSXChart主要成員): TXLSXChartTrendline;
function TXLSXChartSeries.AddErrorBar(ADir: TXLSXChartErrDir): TXLSXChartErrBar;
property TXLSXChartSeries.Trendlines[Index: Integer]: TXLSXChartTrendline;
property TXLSXChartSeries.ErrBarX, ErrBarY: TXLSXChartErrBar;
property TXLSXChartTrendline.主要成員: TXLSXChart主要成員;
property TXLSXChartTrendline.DispEq, DispRSqr: Boolean;
property TXLSXChartTrendline.Order, Period: Integer;
property TXLSXChartErrBar.使用屬性與方法建立、讀取及更新工作表、範圍與物件: TXLSXChartErrValType;
property TXLSXChartErrBar.Value, PlusValue, MinusValue: Double;

另請參閱

TXLSXWorkbook

var Chart: TXLSXChart;
begin
  Chart := Sheet.Charts.Add(xlsxChartColumn, 'Monthly sales', 2, 5, 18, 12);
  Chart.AddSeries('Sales', 'Sheet1!$A$2:$A$13', 'Sheet1!$B$2:$B$13');
  Chart.ValueAxisTitle := 'Amount';
  Chart.Series[0].AddTrendline(xlsxTrendLinear).DispRSqr := True;
  Chart.Series[0].ShowValue := True;
end;

TXLSXWorkbook

• TXLSXChart 與 TXLSXCharts 類別
• TXLSXWorkbook