Home > Back-end >  How to insert chart EXCEL
How to insert chart EXCEL

Time:02-03

(3) using Delphi control Excle two-dimensional figure
In the Form in ExcelApplication ExcelWorkbook and ExcelWorksheet
Var asheet1 achart, range: the variant;

1) thin the first choice when the first work schedule
Asheet1:=ExcelApplication1 Workbooks [1]. The Worksheets [1].

2) add a 2 d figure
Achart:=asheet1. Chartobjects. Add (100100200200);

3) choose 2 d figure form
Achart. Chart. Charttype:=4;

4) to the 2 d figure assignment
Series:=achart chart. Seriescollection;
Range:=sheet1! R2c3: r3c9;
Series. The add (range, true);

Made a according to the above specification, found that won't compile, please
  • Related