Table Data Entry Template

Manually enter or paste data from other sources such as Excel. The entered data will be converted to an R matrix, vector or a data frame.

Technical details

An attempt will be made to interpret the entered data as a numeric vector or matrix. The numeric vector may or may not contain named elements, while the numeric matrix may either be unnamed or have row and column names. If this attempt fails, a character vector or matrix is produced instead. The entered data for a numeric matrix with row and column names should be of the following form:

	Column name 1	Column name 2	Column name 3
Row name 1	Numeric value	Numeric value	Numeric value
Row name 2	Numeric value	Numeric value	Numeric value

If table, row and column titles are to be added to this matrix, the entered data should be of the following form:

Table title
		Column title
		Column name 1	Column name 2	Column name 3
Row title	Row name 1	Numeric value	Numeric value	Numeric value
	Row name 2	Numeric value	Numeric value	Numeric value

Note that the data need not be entered at the top left of the spreadsheet, as any empty rows and columns will be automatically removed. You may enter a table that is at most 200 x 200. If you need to enter more data then upload it as a CSV file.

Options

Add Data... Opens up a blank spreadsheet into which tabular data can be manually entered or pasted.

Automatically tidy the data performs a variety of cleaning operations, such as removing missing values, and changing the underlying type of the data table in order to convert it into a numeric form useful for charting.

Automatically detect row and column names Unselect this if you want to manually adjust whether or not row or column names are present in the data.

First row contains column names If selected, the first row of the table will always be interpreted as the column names.

First column contains row names If selected, the first column of the table will always be interpreted as the row names.

Tidy labels extracts common prefixes from the row labels or vector names to shorten the labels in the chart.

Autofit Set row heights and column widths of the table to fill the iframe. More formatting options are available in the Format tab when this option is selected.

Refer to the section on Data Manipulation in Visualization Options for a description of formatting options.