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.