Generating customized data bound visualizations

摘要

Descried herein are various technologies to visualizing data in a spreadsheet application. Customized visualizations are generated by binding a user-defined equation with a parameter of a primitive visual shape that has been selected by the user to visualized a dataset. The user-defined equation takes as input a value of data in a cell of the spreadsheet application, and the primitive visual shape is displayed to the user as a function of the output of the user-defined equation.

主权项

1. A method, comprising:
in a computer-implemented spreadsheet application, receiving a dataset, the dataset comprises a plurality of data points; receiving a selection of a primitive visual shape, an instance of the primitive visual shape is to visually represent a data point in the dataset, the primitive visual shape has a parameter that at least partially defines appearance of the primitive visual shape; responsive to receiving the selection, binding a user-defined equation to the parameter of the primitive visual shape, such that outputs of the user-defined equation define how the parameter of the primitive visual shape is to appear when respective instances of the primitive visual shape visually represent data points in the data set; executing the user-defined equation using a second data point in the dataset as input to the user-defined equation, such that a value is computed based upon the second data point; assigning the value to the parameter of the instance of the primitive visual shape that is to visually represent the data point; and displaying the instance of the primitive visual shape on a display of a computing device in the spreadsheet application, the instance of the primitive visual shape displayed to represent the data point and to visually indicate that the parameter has the value.