Unlock instant, AI-driven research and patent intelligence for your innovation.

Analysis view for pivot table interfacing

A data perspective and view technology, applied in the input/output process of data processing, electrical digital data processing, special data processing applications, etc., can solve the problems of huge amount of data and difficult to understand.

Inactive Publication Date: 2017-10-17
MICROSOFT TECH LICENSING LLC
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Sometimes the data contained in a spreadsheet can be overwhelming and difficult to understand

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Analysis view for pivot table interfacing
  • Analysis view for pivot table interfacing
  • Analysis view for pivot table interfacing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] Aspects of the disclosed embodiments relate to creating and using analysis view interfaces and objects that can be used to interface with pivot tables.

[0021] Although some pivot table interfaces currently exist, it may still be difficult for users to understand how to navigate the data presented by the pivot table and how to create and / or utilize graphics for the pivot table.

[0022] An analytical view is described in this disclosure that can improve the user experience associated with pivot tables. This analytical view can be used in some embodiments to create graphics that are transient and can be sensitively rotated in and out of view along with other graphics in response to simple gestures, without requiring the user to navigate through complex menu hierarchies and Chart Wizard to navigate.

[0023] Various technical effects and benefits can be obtained by implementing aspects of the disclosed embodiments. As an example, the disclosed embodiments can be used t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Various methods, systems and storage devices are used for creating and utilizing an analysis view for pivot table interfacing. The analysis view can be created with a visualization that reflects data summarized in the pivot table automatically in response to detecting user input directed at a particular data field (i.e., cell) of the pivot table and without requiring any additional user input, such as user input required to navigate a chart wizard or any other graphics interface. The visualization includes at least one selectable and transient object that is configured for being selected and dragged out of the analysis view window and which persists even after the analysis view window is closed, unless it is first dragged outside of the boundaries of the analysis view window and without requiring additional user input for separately closing and / or removing the transient object.

Description

Background technique [0001] Many types of computer applications exist to help users access and manipulate data, including spreadsheet applications. These applications can also be simply referred to as spreadsheets. Excel is an example of a spreadsheet. [0002] Spreadsheets typically present data in cells within a grid of columns and rows. A spreadsheet can include a single worksheet or a compilation of worksheets in a workbook. Each cell in the spreadsheet can contain a specific value entered by the user, or a formula that defines a relationship to the data contained in one or more other cells. When a formula is provided in a cell, the corresponding value will be displayed to the user. [0003] Sometimes, the data contained in spreadsheets can be overwhelming and difficult to understand. Accordingly, various tools are provided to summarize the data and the relationships defined therein. A pivot table is a data summarization tool found in spreadsheets and other data visu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/24G06F3/0482G06F3/0481G06F3/0486
CPCG06F3/04817G06F3/0482G06F3/0486G06F40/18
Inventor M·奥林格M·G·达文波特
Owner MICROSOFT TECH LICENSING LLC