US 12,112,123 B2
Generating charts from data in a data table
Fernanda Viégas, Mountain View, CA (US); Martin Wattenberg, Winchester, MA (US); Daniel Smilkov, Boston, MA (US); James Wexler, Newton, MA (US); and Daniel Gundrum, New York, NY (US)
Assigned to Google LLC, Mountain View, CA (US)
Filed by Google LLC, Mountain View, CA (US)
Filed on Jun. 30, 2023, as Appl. No. 18/217,436.
Application 18/217,436 is a continuation of application No. 17/403,830, filed on Aug. 16, 2021, granted, now 11,694,024.
Application 17/403,830 is a continuation of application No. 15/719,425, filed on Sep. 28, 2017, granted, now 11,093,703, issued on Aug. 17, 2021.
Claims priority of provisional application 62/401,647, filed on Sep. 29, 2016.
Prior Publication US 2024/0005091 A1, Jan. 4, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 40/00 (2020.01); G06F 3/0482 (2013.01); G06F 16/22 (2019.01); G06F 16/248 (2019.01); G06F 40/177 (2020.01); G06F 40/18 (2020.01); G06F 40/216 (2020.01); G06T 11/20 (2006.01)
CPC G06F 40/18 (2020.01) [G06F 3/0482 (2013.01); G06F 16/2282 (2019.01); G06F 16/248 (2019.01); G06F 40/177 (2020.01); G06F 40/216 (2020.01); G06T 11/206 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method for generating a chart suggestion list using data present in a data table of a collaborative spreadsheet stored in a cloud-based environment, the method 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 as input to a machine learning model;
creating, using one or more outputs of the machine learning model, one or more suggested charts for the data table based on one or more 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.