PERSISTENT FORMATTING FOR INTERACTIVE CHARTS

• US 20160314606A1
• Filed: 06/22/2016
• Published: 10/27/2016
• Est. Priority Date: 12/05/2005
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Tolle, Kristin Michele, Monroe, Jenefer Lea, Heijster, Stephen Michael
• Application Number:
  US15/189,952
• Publication Number:
  US 20160314606A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06T 11/001 Texturing; Colouring; Generation of texture or colour inpainting G06T5/77
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

User requested format alterations to interactive chart elements, including, but not limited to, legends, axes, gridlines, data labels, axes labels, error bars, and datapoints, whether they be represented as points, bars, pie wedges, etc., are persisted in spite of chart navigations, underlying data changes and/or format alterations. Interactive chart element format persistence is maintained by the association and storing of data identifying a format change on the data and index rule for the respective chart element.

Claims

1. A computer system comprising:

at least one processing unit; and

memory comprising instructions stored thereon that when executed by at least one processing unit cause at least one processing unit to perform acts for applying formatting for an interactive chart comprising;

accessing the interactive chart in the computer system, with the interactive chart representing computer-readable data stored in the computer system, and with the interactive chart being configured to be displayed on a computer display device;

applying a first initial default format to a first chart element, a second initial default format to a second chart element, and a third initial default format to a third chart element displayed in the interactive chart, the first, second, and third initial default formats each differentiating, respectively, the first, second, and third chart elements from one another, when the first, second, and third chart elements are displayed together;

hiding the third chart element from being displayed in the interactive chart so that the third chart element is not visible, the interactive chart continuing to display the first chart element and the second chart element;

changing, responsive to the hiding, a relative position between the first chart element and the second chart element; and

changing, responsive to the hiding, a formatting of the second chart element from the second initial default format to an altered default format, the altered default format differentiating the second chart element from the first chart element, when the first and second chart elements are displayed together.

2. The computer system of claim 1, wherein the acts comprise:

redisplaying the third chart element in the interactive chart after the changing; and

reapplying the second initial default format to the second chart element responsive to the redisplaying.

3. The computer system of claim 1, wherein the acts comprise:

displaying, in the interactive chart, a child chart element of the first chart element;

applying the first initial default format to the child chart element;

receiving a request to apply a user override format to the child chart element, the user override format overriding the first initial default format applied to the child chart element; and

applying the user override format to the child chart element when the child chart element is displayed while continuing to apply the first initial default format to the first chart element when the first chart element is displayed.

4. The computer system of claim 3, wherein the child chart element and the first chart element are not displayed concurrently.

5. The computer system of claim 1, wherein the acts comprise:

applying the first initial default format to a child chart element of the first chart element when the child chart element is displayed in the interactive chart;

receiving a request to apply a user override format to the first chart element, the user override format overriding the first initial default format applied to the first chart element and to the child chart element; and

applying the user override format to the first chart element when the first chart element is displayed and to the child chart element when the child chart element is displayed.

6. The computer system of claim 1, wherein the acts comprise:

displaying a first child chart element and a second child chart element of the first chart element in the interactive chart, the first initial default format applied to the first child chart element and to the second child chart element;

receiving a request to apply a user override format to the first child chart element, the user override format overriding the first initial default format applied to the first child chart element; and

applying the user override format to the first child chart element when the first child chart element is displayed while continuing to apply the first initial default format to the second child chart element when the second child chart element is displayed.

7. The computer system of claim 1, wherein the interactive chart comprises a PivotChart.

8. The computer system of claim 7, wherein:

the PivotChart is generated from an interactive table,

the interactive table is built from a data cache, and

the data cache is created from data in a data source.

9. The computer system of claim 1, wherein the acts comprise:

applying a user override format to at least one of the first chart element, the second chart element, or the third chart element; and

storing a property of the user override format in a data tuple associated with the at least one of the first chart element, the second chart element, or the third chart element.

10. A computer system comprising:

at least one processing unit; and

memory comprising instructions stored thereon that when executed by at least one processing unit cause at least one processing unit to perform acts comprising;

displaying an interactive chart comprising at least a first chart element, the first chart element displayed in a default format, with the interactive chart representing computer-readable data stored in the computer system, and with the interactive chart being displayed on a computer display device;

receiving a first request to expand the first chart element such that a first child chart element and a second child chart element of the first chart element are displayed;

displaying the first child chart element and the second child chart element in the default format and hiding the first chart element responsive to the receiving a first request;

receiving a second request to apply a user override format to the first child chart element, the user override format overriding the default format applied to the first child chart element;

applying the user override format to the first child chart element responsive to the receiving a second request;

receiving a third request to collapse the first child chart element and the second child chart element such that the first chart element is displayed;

redisplaying the first chart element in the default format and hiding the first child chart element and the second child chart element responsive to the receiving a third request;

receiving a fourth request to apply an updated format to the first chart element, the updated format overriding the default format;

applying the updated format to the first chart element responsive to the receiving a fourth request;

receiving, after the applying the updated format to the first chart element, a fifth request to expand the first chart element such that the first child chart element and the second child chart element are displayed; and

redisplaying the first child chart element in the user override format and displaying the second child chart element in the updated format and hiding the first chart element responsive to the receiving a fifth request.

11. The computer system of claim 10, with the interactive chart comprising a PivotChart.

12. The computer system of claim 10, wherein the acts comprise:

storing data associated with the user override format in a data tuple associated with the first child chart element responsive to the receiving a second request.

13. The computer system of claim 10, with the user override format comprising a user override color.

14. The computer system of claim 10, with the interactive chart comprising a second chart element displayed concurrently with the first chart element and concurrently with the first child chart element and the second child chart element.

15. The computer system of claim 14, where data associated with the first chart element and data associated with the second chart element are mutually exclusive.

16. The computer system of claim 10, with the updated format not applied to the first child chart element.

17. A computer system comprising:

at least one processing unit; and

memory comprising instructions stored thereon that when executed by at least one processing unit cause at least one processing unit to perform acts for applying formatting for an interactive chart comprising;

accessing the interactive chart in the computer system, with the interactive chart representing computer-readable data stored in the computer system, and with the interactive chart being configured to be displayed on a computer display device;

applying a first initial default format to a first chart element, a second initial default format to a second chart element, and a third initial default format to a third chart element displayed in the interactive chart, the first chart element, the second chart element, and the third chart element corresponding to bar chart elements, and the first, second, and third initial default formats each differentiating, respectively, the first, second, and third chart elements from one another;

hiding the third chart element from being displayed in the interactive chart so that the third chart element is not visible, the interactive chart continuing to display the first chart element and the second chart element; and

changing, responsive to the hiding, a formatting of the second chart element from the second initial default format to an altered default format, the altered default format differentiating the second chart element from the first chart element.

18. The computer system of claim 17, with the changing a formatting of the second chart element comprising:

changing a color of the second chart element.

19. The computer system of claim 17, wherein the acts comprise:

changing, responsive to the hiding, a relative position between the first chart element and the second chart element.

20. The computer system of claim 17, wherein the acts comprise:

redisplaying the third chart element in the interactive chart after the changing; and

reapplying the second initial default format to the second chart element responsive to the redisplaying.