A two-dimensional array representing the input data on tabular form. This input can be used when the data is already parsed, for example from a grid view component. Each cell can be a string or number. If not switchRowsAndColumns is set, the columns are interpreted as series.
The callback that is evaluated when the data is finished loading, optionally from an external source, and parsed. The first argument passed is a finished chart options object, containing the series. These options can be extended with additional options and passed directly to the chart constructor.
A comma delimited string to be parsed. Related options are startRow, endRow, startColumn and endColumn to delimit what part of the table is used. The lineDelimiter and itemDelimiter options define the CSV delimiter formats.. . The built-in CSV parser doesn't support all flavours of CSV, so in some cases it may be necessary to use an external CSV parser. See this example of parsing CSV through the MIT licensed Papa Parse library.
Which of the predefined date formats in Date.prototype.dateFormats to use to parse date values. Defaults to a best guess based on what format gives valid and ordered dates.. . Valid options include:. .
YYYY-mm-dd
.dd/mm/YYYY
.mm/dd/YYYY
.dd/mm/YY
.mm/dd/YY
. .The decimal point used for parsing numbers in the CSV.
In tabular input data, the last column (indexed by 0) to use. Defaults to the last column containing data.
In tabular input data, the last row (indexed by 0) to use. Defaults to the last row containing data.
Whether to use the first row in the data set as series names.
The key for a Google Spreadsheet to load. See general information on GS.
The Google Spreadsheet worksheet to use in combination with googleSpreadsheetKey. The available id's from your sheet can be read from https://spreadsheets.google.com/feeds/worksheets/{key}/public/basic
Item or cell delimiter for parsing CSV. Defaults to the tab character \t
if a tab character is found in the CSV string, if not it defaults to ,
.
Line delimiter for parsing CSV.
A callback function to parse string representations of dates into JavaScript timestamps. Should return an integer timestamp on success.
A callback function to access the parsed columns, the two-dimentional input data array directly, before they are interpreted into series data and categories. Return false
to stop completion, or call this.complete()
to continue async.
The same as the columns input option, but defining rows intead of columns.
An array containing object with Point property names along with what column id the property should be taken from.
In tabular input data, the first column (indexed by 0) to use.
In tabular input data, the first row (indexed by 0) to use.
Switch rows and columns of the input data, so that this.columns
effectively becomes the rows of the data set, and the rows are interpreted as series.
A HTML table or the id of such to be parsed as input data. Related options are startRow
, endRow
, startColumn
and endColumn
to delimit what part of the table is used.