# US 10,311,141 B1 · Data driven spreadsheet chart system > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 10,311,141 B1 - Document ID: US10311141B1 - Status: Granted - Kind: B1 - Application number: 14/860,468 - Filed: 2015-09-21 - Granted: 2019-06-04 - Earliest claimed: 2015-09-21 - Assignees: Workday, Inc. - Applicants: Workday, Inc. - Inventors: Terry M. Olkin - Web page: https://patentgrep.com/patent/US10311141B1 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A data-driven spreadsheet chart system includes an interface and a processor. The interface is to receive a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data. The processor is to host the spreadsheet document and render a visual representation of the data for display entirely within the cell. ## Claims ### Claim 1 A data-driven spreadsheet chart system, comprising an interface to: receive a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data, wherein the formula takes as arguments a chart-type parameter and a primary-data parameter, wherein the formula takes a base configuration parameter, the base configuration parameter including a location of a legend, a title, a format and a location of an axis, or any combination thereof, and wherein the formula takes an override parameter to override the base configuration parameter, the base configuration parameter corresponding to a standard formatting style; and a processor to: host the spreadsheet document; compile the formula into a byte code version, comprising to: perform a syntactic check, a semantic check, or both on the formula; and in response to a determination that syntactic check, a semantic check, or both are completed without error, generate the byte code version from the formula using a compiler; and render a visual representation of the data for display entirely within the cell based on the base configuration parameter, wherein the rendering of the visual representation is performed using the byte code version, wherein the visual representation comprises the legend, the title, the axis, or any combination thereof, wherein the visual representation comprises a chart, wherein the visual representation exists in the same plane as neighboring cells of the cell, and wherein the visual representation exists in the same sheet of the spreadsheet document as the neighboring cells of the cell. ### Claim 2 (depends on 1) The system of claim 1, wherein the function comprises a chart function. ### Claim 3 (depends on 1) The system of claim 1, wherein the processor is to store the byte code version. ### Claim 4 (depends on 1) The system of claim 1, wherein the cell is created by merging multiple cells. ### Claim 5 (depends on 1) The system of claim 1, wherein the chart has a type. ### Claim 6 (depends on 5) The system of claim 5, wherein the type is a sparkline. ### Claim 7 (depends on 5) The system of claim 5, wherein the type comprises one or more of the following: a line type, a pie type, a column type, a bar type, a scatter type, a tree type, a gauge type, a bubble type, and an area type. ### Claim 8 (depends on 1) The system of claim 1, wherein the cell includes an argument that refers to a second formula nested in the cell or of a second cell. ### Claim 9 (depends on 1) The system of claim 1, wherein the formula takes a secondary-data parameter. ### Claim 10 (depends on 1) The system of claim 1, wherein changing the arguments results in an automatic change to the visual representation of the data. ### Claim 11 (depends on 1) The system of claim 1, wherein the processor is to determine whether a user is authorized to access the set of data. ### Claim 12 A method for data-driven spreadsheet chart system, comprising: receiving a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data, wherein the formula takes as arguments a chart-type parameter and a primary-data parameter wherein the formula takes a base configuration parameter, the base configuration parameter including a location of a legend, a title, a format and a location of an axis, or any combination thereof, and wherein the formula takes an override parameter to override the base configuration parameter, the base configuration parameter corresponding to a standard formatting style; hosting the spreadsheet document; compiling the formula into a byte code version, comprising: performing a syntactic check, a semantic check, or both on the formula; and in response to a determination that syntactic check, a semantic check, or both are completed without error, generating the byte code version from the formula using a compiler; and rendering, using a processor, a visual representation of the data for display entirely within the cell based on the base configuration parameter, wherein the rendering of the visual representation is performed using the byte code version, wherein the visual representation comprises a chart, wherein the visual representation comprises the legend, the title, the axis, or any combination thereof, wherein the visual representation exists in the same plane as neighboring cells of the cell, and wherein the visual representation exists in the same sheet of the spreadsheet document as the neighboring cells of the cell. ### Claim 13 A computer program product for data-driven spreadsheet chart system, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for: receiving a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data, wherein the formula takes as arguments a chart-type parameter and a primary-data parameter, wherein the formula takes a base configuration parameter, the base configuration parameter including a location of a legend, a title, a format and a location of an axis, or any combination thereof, and wherein the formula takes an override parameter to override the base configuration parameter, the base configuration parameter corresponding to a standard formatting style; hosting the spreadsheet document; compiling the formula into a byte code version, comprising: performing a syntactic check, a semantic check, or both on the formula; and in response to a determination that syntactic check, a semantic check, or both are completed without error, generating the byte code version from the formula using a compiler; and rendering, using a processor, a visual representation of the data for display entirely within the cell based on the base configuration parameter, wherein the rendering of the visual representation is performed using the byte code version, wherein the visual representation comprises a chart, wherein the visual representation comprises the legend, the title, the axis, or any combination thereof, wherein the visual representation exists in the same plane as neighboring cells of the cell, and wherein the visual representation exists in the same sheet of the spreadsheet document as the neighboring cells of the cell.