Generating charts from data in a data table

A system for generating a chart suggestion list using data present in a data table of a collaborative spreadsheet stored in a cloud-based environment, the system comprising:

• a memory device storing instructions;
• and
• a processing device coupled to the memory device, the processing device to execute the instructions to perform operations comprising:
• providing the collaborative spreadsheet to be displayed on a first device of a first user, wherein the collaborative spreadsheet is shared with a second user by granting permissions to the second user that allows the second user to concurrently edit the collaborative spreadsheet on a second device while the first user edits the collaborative spreadsheet on the first device;
• providing the data table, one or more data types of a plurality of cells of the data table and one or more statistics pertaining to the plurality of cells as input to a machine learning model to obtain one or more outputs indicating one or more chart types for the data table;
• creating one or more suggested charts based on the one or more indicated chart types, wherein each of the one or more suggested charts represents at least a subset of the data in the data table;
• generating a chart suggestion list including at least one of the one or more suggested charts;
• presenting the chart suggestion list on the first device of the first user;
• receiving additional data in the data table from the second device of the second user, the additional data added by the second user while editing the collaborative spreadsheet on the second device concurrently with the editing of the collaborative spreadsheet on the first device;
• revising at least one of the created one or more suggested charts to generate one or more revised suggested charts representing the additional data from the second device of the second user;
• updating the chart suggestion list presented on the first device of the first user to include at least one of the one or more revised suggested charts;
• and
• responsive to receiving, from the first device of the first user, a selection of a suggested chart of the chart suggestion list, associating the suggested chart with the collaborative spreadsheet for presentation on the first device of the first user.

A non-transitory computer-readable storage media storing instructions, which when executed by one or more processing devices, cause the one or more processing devices to perform operations for generating a chart suggestion list using data present in a data table of a collaborative spreadsheet stored in a cloud-based environment, the operations comprising:

• providing the collaborative spreadsheet to be displayed on a first device of a first user, wherein the collaborative spreadsheet is shared with a second user by granting permissions to the second user that allows the second user to concurrently edit the collaborative spreadsheet on a second device while the first user edits the collaborative spreadsheet on the first device;
• providing the data table, one or more data types of a plurality of cells of the data table and one or more statistics pertaining to the plurality of cells as input to a machine learning model to obtain one or more outputs indicating one or more chart types for the data table;
• creating one or more suggested charts based on the one or more indicated chart types, wherein each of the one or more suggested charts represents at least a subset of the data in the data table;
• generating a chart suggestion list including at least one of the one or more suggested charts;
• presenting the chart suggestion list on the first device of the first user;
• receiving additional data in the data table from the second device of the second user, the additional data added by the second user while editing the collaborative spreadsheet on the second device concurrently with the editing of the collaborative spreadsheet on the first device;
• revising at least one of the created one or more suggested charts to generate one or more revised suggested charts representing the additional data from the second device of the second user;
• updating the chart suggestion list presented on the first device of the first user to include at least one of the one or more revised suggested charts;
• and
• responsive to receiving, from the first device of the first user, a selection of a suggested chart of the chart suggestion list, associating the suggested chart with the collaborative spreadsheet for presentation on the first device of the first user.