Three dimensional conditional formatting

Patent metadata

Field	Value
Publication number	US-10067635-B2
Application number	US-201615158609-A
Country	US
Kind code	B2
Filing date	May 19, 2016
Priority date	Jul 29, 2013
Publication date	Sep 4, 2018
Grant date	Sep 4, 2018

Abstract

Three dimensional, conditional formatting based data visualization is provided. Received underlying data may be analyzed and one or more portions of the underlying data that are of interest to a user determined. The portions may be selected actively by a user of automatically determined based on a variation of values in each portion, values of data points in each portion, a usage history of the user, and/or a credential of the user. A background image may be generated by converting the tabular data into a three dimensional image or selecting and image or a graphic associated with the underlying data. The visualization(s) may then be displayed over the background. Scenes may be selected for animated slide shows or movies.

First claim

What is claimed is:

1. A server configured to provide three dimensional, conditional formatting based data visualization, the server comprising:
a memory configured to store instructions;
a communication module configured to exchange data with one or more computing devices; and
a processor coupled to the memory and the communication module, the processor adapted to execute a data processing application M conjunction with instructions stored in the memory wherein the processor is configured to:
receive underlying data;
analyze the underlying data;
determine a portion of the underlying data to be visualized;
determine a background for a visualization through one of conversion of a tabular presentation of the underlying data to a three dimensional background image, selection of an image associated with the underlying data, and selection of a graphic associated with the underlying data;
provide the visualization of the portion of the underlying data over the determined background to the one or more computing devices to be displayed; and
adjust one or more placement and perspective parameters of the visualization and the background image for enhanced presentation of an overall scene on the one or more computing devices through one of a touch/gesture input, a selection of commands, an automatic selection received from the one or more computing devices.

2. The server of claim 1 , wherein the processor is further configured to:
provide a miniaturized graphic representation of a scene comprising the background and the visualization to the one or more computing devices to be displayed; and
complement the miniaturized graphic representation of the scene with textual information.

3. The server of claim 1 , wherein the processor is further configured to:
conditionally format the visualization based on an aspect of the portion of the underlying data that is different from another aspect represented by the visualization.

4. The server of claim 1 , wherein the processor is further configured to:
provide a history of visualizations of the portion of the underlying data over the determined background through a plurality of miniaturized graphic representations presented in a vicinity of the presented visualization to the one or more computing devices to be displayed.

5. The server of claim 1 , wherein the processor is further configured to:
save a plurality of scene sequences along with animation parameters as multiple slide presentations or movies visualizing the underlying data; and
provide the plurality of scene sequences to the one or more computing devices to be displayed.

6. The server of claim 1 , wherein the processor is further configured to:
provide a menu of actions associated with the background image and the visualization to the one or more computing devices to be displayed, wherein the menu includes one or more of a chart type for the visualization, an aggregation dimension for the visualization, a height dimension for the visualization, and a category of the scene; and
provide another menu for selection of one or more scenes for one of a slide show and a movie to the one or more computing devices to be displayed, wherein the other menu includes selections for animation and transition parameters for the slide show and the movie.

7. The server of claim 1 , wherein the data processing application includes a visualization engine configured to generate the visualization.

8. A method executed on a computing device for three dimensional, conditional formatting based data visualization, the method comprising:
receiving underlying data;
analyzing the underlying data;
determining a portion of the underlying data that is of interest to a user based on one or more of a variation of values in each portion, values of data points in each portion, a usage history of the user, and a credential of the user;
determining a background for a visualization of the portion of the underlying data, wherein the background is based on an image associated with the underlying data;
providing the visualization of the portion of the underlying data over the determined background to be displayed; and
adjusting one or more placement and perspective parameters of the visualization and the background for enhanced presentation of an overall scene through one of a touch/gesture input, a selection of commands, an automatic selection.

9. The method of claim 8 , further comprising:
providing a control element to he displayed for creation of one of a slide show and a movie scene based on the underlying data.

10. The method of claim 8 , further comprising:
placing the visualization over a corresponding portion of underlying data in the background; and
aligning the visualization with the corresponding portion of underlying data.

11. The method of claim 10 , further comprising:
providing a history of visualizations of the portion of the underlying data over the determined background through a plurality of miniaturized graphic representations presented in a vicinity of the presented visualization to be displayed.

12. The method of claim 8 , further comprising:
upon user confirmation, saving the background and the visualization as a scene; and
providing miniaturized graphic representations of a plurality of scenes corresponding to a plurality of backgrounds and a plurality of visualizations to be displayed.

13. The method of claim 8 , wherein one or both of the background and the visualization are three-dimensionally presented.

14. The method of claim 8 , wherein the visualization is one of a bar chart, a pie chart, a scatter chart, and a line graph.

15. A system configured to provide three dimensional, conditional formatting based data visualization, the system comprising:
a first server configured to manage data associated with a hosted service; and
a second server configured to provide the hosted service, the hosted service including one or more of a spreadsheet application, a database application, a presentation application, a note taking application, and a word processing application, wherein the second server is configured to execute a visualization engine, the visualization engine configured to:
receive underlying data from the second server;
analyze the underlying data;
determine a portion of the underlying data to be visualized that is of interest to a user based on one or more of a variation of values in each portion, values of data points in each portion, a usage history of the user, and a credential of the user;
determine a background image associated with the underlying data;
provide the visualization of the portion of the underlying data over the determined background image to one or more computing devices to be displayed, wherein the visualization is conditionally formatted such that the visualization and one or more format characteristics of the visualization represent different aspects of the portion of the underlying data; and

adjust one or more placement and perspective parameters of the visualization and the background image for enhanced presentation of an overall scene on the one or more computing devices through one of a touch/gesture input, a selection of commands, an automatic selection received from the one or more computing devices.

16. The system of claim 15 , wherein the visualization engine is configured to determine the background image by converting a tabular presentation of the underlying data to a three dimensional background image.

17. The system of claim 15 , wherein the visualization engine is further configured to:
generate a plurality

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Peev Igor
• Ruble Brian Scott

Classifications

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F40/103

  Formatting, i.e. changing of presentation of documents (automatic justification G06F40/189; automatic line break hyphenation G06F40/191) · CPC title

• G06F3/0488

  using a touch-screen or digitiser, e.g. input of commands through traced gestures · CPC title

• G06F3/0484

  for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range · CPC title

• G06F3/04815 Primary

  Interaction with a metaphor-based environment or interaction object displayed as three-dimensional [3D], e.g. changing the user viewpoint with respect to the environment or object · CPC title