Version Ref: 6.1 (USP 6.0.02)
Syntax:
handle = XL_CHART(type [, title [, xname [, yname [, row [, col [, stylenum
[, sheet [, xoff [, yoff [, xscale [, yscale]]]]]]]]]]])
Add a new chart to the XLSX document.
Parameters -
type : Type of chart to create. Must be one of the following values.
"area"
"area_stacked"
"area_stacked_percent"
"bar"
"bar_stacked"
"bar_stacked_percent"
"column"
"column_stacked"
"column_stacked_percent"
"doughnut"
"line"
"line_stacked"
"line_stacked_percent"
"pie"
"scatter"
"scatter_straight"
"scatter_stright_markers"
"scatter_smooth"
"scatter_smooth_markers"
"radar"
"radar_with_markers"
"radar_filled"
title : The title for this chart.
xname : The title for the x-axis.
yname : The title for the y-axis.
row : Row to place the cell (0 indexed).
col : Column to place the cell (0 indexed).
stylenum : Number of the built in Excel style to use. Must be between
"1" and "48". The default style is 2. The value is one of
the 48 built-in styles available on the "Design" tab in
Excel 2007.
sheet : Handle to sheet to insert the chart on. Use blank, "0", or
"-1" to use the default sheet.
xoff : X axis offset to place the chart, in pixels.
yoff : Y axis offset to place the chart, in pixesl.
xscale : Scale the chart along the x axis. e.g. "1", "0.5" "2". Value
cannot be negative.
yscale : Scale the chart along the x axis. e.g. "1", "0.5" "2". Value
cannot be negative.
Returns a handle to a new chart object on successs and "-1" on error.
XL_ERROR() can be called to return the last error.
Note: The chart functions do not use the auto counter found in the sheets
and instead will default to "0", "0" or "A1" when used for insertion.