Mapping raw spreadsheet data into graphs on arbitrary subsets of the data

An information processing system, the information processing system comprising:

• a memory;
• a processor communicatively coupled to the memory;
• a spreadsheet module communicatively coupled to the memory and the processor;
• and
• a spreadsheet user interface communicatively coupled to the spreadsheet module, wherein the spreadsheet user interface module is configured to perform a method comprising:
• displaying a set of tabular data visually arranged at least in rows and columns;
• receiving a user selection of a first dimension of data in a series, wherein the first dimension of data is visually included in a first column in the set of tabular data;
• receiving a user selection of at least one series identifier, wherein the at least one series identifier is visually included in a third column in the set of tabular data;
• receiving a user selection of at least one series identifier, wherein the at least one series identifier is visually included in a third column in the set of tabular data, the user selection comprising only a column identifier associated with the third column, and wherein the at least one series identifier is separate and distinct from a set of data under the third column;
• automatically finding, without manual intervention and in response to receiving the user selection of the at least one series identifier, each distinct set of data entries within the third column, wherein each distinct set of data entries identifies a separate data series in the tabular data comprising a plurality of entries within the first column and a plurality of entries in the second column, wherein each distinct set of data entries in the plurality of distinct sets of data entries is free from association with a separate data series identifier;
• and
• automatically creating, without manual intervention, a graphical representation of the user selected tabular data based on
• the selected first dimension of data in the series,
• the selected second dimension of data in the series, and
• the selected series identifier,
• the automatically creating further comprising independently plotting each of the separate data series against the first dimension and the second dimension.

A non-transitory computer readable medium for graphically representing data in a spreadsheet, the computer readable medium comprising instructions for:

• displaying a set of tabular data visually arranged at least in rows and columns;
• receiving a user selection of a first dimension of data in a series, wherein the first dimension of data is visually included in a first column in the set of tabular data;
• receiving a user selection of a second dimension of data in the series, wherein the second dimension of data is visually included in a second column in the set of tabular data;
• receiving a user selection of at least one series identifier, wherein the at least one series identifier is visually included in a third column in the set of tabular data, and wherein the at least one series identifier is separate and distinct from a set of data under the third column;
• automatically finding, without manual intervention and in response to receiving the user selection of the at least one series identifier, a plurality of distinct sets of data entries within the third column, wherein each distinct set of data entries in the plurality of distinct sets identifies a separate data series in the tabular data comprising a plurality of entries within the first column and a plurality of entries in the second column, wherein each distinct set of data entries in the plurality of distinct sets of data entries is free from association with a separate data series identifier;
• and
• automatically creating, without manual intervention, a graphical representation of the user selected tabular data based on
• the selected first dimension of data in the series,
• the selected second dimension of data in the series, and
• the selected series identifier,
• wherein for each separate data series, the graphical representation includes a data point at an intersection of the first dimension of data and the second dimension of data, data values of the first dimension of data and the second dimension of data being found at respective first and second intersections of a row in the visually arranged tabular data intersecting with the first column and the second column, and further wherein the selected series identifier is found at the intersection of the row and the third column.