|
|
Creating a statistical table
Make a table with statistical information and build charts based on this data:
- create a worksheet with the information about medal number (Api/CreateColorFromRGB,
Api/GetActiveSheet, ApiRange/SetAlignHorizontal,
ApiRange/SetFontColor, ApiRange/SetFontName,
ApiRange/SetFontSize, ApiRange/SetValue,
ApiWorksheet/GetRange,
ApiWorksheet/SetName);
- create a table with the specified data (ApiWorksheet/FormatAsTable,
ApiWorksheet/SetColumnWidth);
- add an image to the table (ApiWorksheet/AddImage);
- add a chart to represent the table data (ApiChart/SetHorAxisTitle,
ApiChart/SetLegendPos, ApiChart/SetShowDataLabels,
ApiChart/SetTitle, ApiChart/SetVerAxisTitle,
ApiWorksheet/AddChart).
|