CN101322119B - Persistent formatting for interactive charts - Google Patents

Persistent formatting for interactive charts Download PDF

Info

Publication number
CN101322119B
CN101322119B CN2006800456465A CN200680045646A CN101322119B CN 101322119 B CN101322119 B CN 101322119B CN 2006800456465 A CN2006800456465 A CN 2006800456465A CN 200680045646 A CN200680045646 A CN 200680045646A CN 101322119 B CN101322119 B CN 101322119B
Authority
CN
China
Prior art keywords
chart element
chart
data
replacement value
interactive
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN2006800456465A
Other languages
Chinese (zh)
Other versions
CN101322119A (en
Inventor
K·M·托勒
J·L·摩恩诺
S·M·海杰斯特
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Technology Licensing LLC
Original Assignee
Microsoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Microsoft Corp filed Critical Microsoft Corp
Publication of CN101322119A publication Critical patent/CN101322119A/en
Application granted granted Critical
Publication of CN101322119B publication Critical patent/CN101322119B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/10—Services
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T11/00—2D [Two Dimensional] image generation
    • G06T11/20—Drawing from basic elements, e.g. lines or circles
    • G06T11/206—Drawing of charts or graphs
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T11/00—2D [Two Dimensional] image generation
    • G06T11/001—Texturing; Colouring; Generation of texture or colour
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T11/00—2D [Two Dimensional] image generation
    • G06T11/20—Drawing from basic elements, e.g. lines or circles

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Health & Medical Sciences (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • User Interface Of Digital Computer (AREA)
  • Processing Or Creating Images (AREA)

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.

Description

Formatting to the lasting existence of interactive table
Background technology
Form and chart all are the instruments that can be on computers produces and be used to convey a message by the computer user through software program.Although form and chart all are the popular tool that is used to store, pass on and analyze data, they have some recapitulative differences.Chart is a figure in itself more, is used to represent data, for example, and as the point on the line on the x-y axle, perhaps as various in the bar chart.By contrast, form generally is tabular more, is used to represent data, for example, and as the numeral in each row and row.And chart concentrates on the total and/or total of data sink usually, and form ordinary representation more data details.Chart can be stored in a series of data in the form through diagrammatic representation.
Form such as PivotTables (PivotTable) that some computing machines produce are the IDA instruments; They allow user's joint account and the data of analyzing from each provenance, and these sources include but not limited to Excel worksheet, relational database, text and OLAP cube.Equally, the chart that some computing machines produce, for example the pivot chart has the ability that becomes the interactive videodata analysis tool.
Interactive table is provided at the ability of carrying out various interactive changes and navigation on the represented data to the user, and this presents the interactive table analysis tool with the method that is fit to data itself.For example, the user can be with being presented at one or more special domain that the data element such as data point in the interactive table is filtered into the subclass of data set or is filtered into data set.The user also can or remove the data element prime field to the interactive table interpolation.In addition, the user can navigate interactive table to analyze particular data territory and/or data point.The navigate example of interactive table of user includes but not limited to get into (drilling), launches and folds.
The example that gets into is that the data point or the element of one of them father's data field of more summarizing (for example, food profit) is presented in the interactive table at first.The user can get into this recapitulative food profit data field to show more concrete subnumber strong point, for example dairy produce profit data point, vegetables profit data point and snack categories profit data point.On the contrary, the data set view of the collapsible interactive table of user more to be summarized.In the example in front; If dairy produce profit, vegetables profit and snack categories profit data point is current in interactive table, shows; Then the collapsible chart of user makes all these three sub-data points be combined into a food father profit data point of more summarizing, and is replaced by it.
Also deployable interactive table is to show other data field.In the example in front, if the data point of food profit father data field or element is current is presented in the interactive table, then chart can launch to show the data point of food cost second father's data field.Another example as launching navigation is presented in the interactive table if the data point of dairy produce profit, vegetables profit and snack categories profit is current, and then chart can be unfolded to show another fruit profit subnumber strong point.
The also refreshable data from the basic data source that is used to produce interactive table of user, no matter it is this locality or external data source, so that guarantee that chart is through the most current information of graphic depiction.
In addition, for example because of aesthetic reasons, the user can change the outward appearance of interactive table.For example, interactive table user possibly want a chart element such as chart legend is moved to the lower right corner from the lower left corner of chart, perhaps possibly want to change the font or the color of legend.
All these changes and navigation need the interactive table analysis tool of high flexible.Yet various interactive table changes need the time to accomplish, especially when the user carries out many changes.Can not be kept behind various changes and navigation or the Refresh Data in that interactive table is carried out if user's formatting (formatting) changes, then user's efficient can suffer damage.In addition, interactive table is generally efficient inadequately, and even possibly abandoned, reason is that the user is reluctant to use IDA instrument flexibly owing to formatting baffles.
Summary
Provide this summary to introduce some notions that further describe in the following detailed description with reduced form.This generally if it were not for identifying key or the essential characteristic that requires the protection theme, neither be used to help to confirm to require the scope of protection theme.
Embodiment described here is included in the change to the interactive table element sustainable the existence (persist) that allows user's request in the face of for example to the change of chart, chart navigation and to the refreshing of the basic data that is used for producing chart the time.
In the one side of an embodiment, user request is to continue existence through the index rule of information and interactive map table element that direct correlation and storage are used to appear the change of format of relevant data to the visual change of interactive table element format or user's replacement value (override).
Description of drawings
Describe these and further feature referring now to the accompanying drawing of some embodiment and example, these accompanying drawings are intended to illustration and unrestricted the present invention, in the accompanying drawings:
Fig. 1 is a diagram of supporting the embodiment framework of one or more interactive table.
Fig. 2 is the embodiment that can be used for the formatting type of interactive map table element.
Fig. 3 A describes to have the exemplary interactive table of default style formatting.
Fig. 3 B describes the example of the interactive table of folding Fig. 3 A.
Fig. 4 A describes to have the exemplary interactive table of default style formatting.
Fig. 4 B describe to get into the example of interactive table of Fig. 4 A with the daughter element of father's element of showing in the interactive table that appears Fig. 4 A.
The example that user's replacement value style format of the daughter element of the interactive table of Fig. 4 C depiction 4B changes.
Fig. 5 A describes the example that user's replacement value style format of father's element of interactive table changes.
The interactive table that Fig. 5 B describes to get into Fig. 5 A is with the example of the daughter element of father's element of showing in the interactive table that is emerging in Fig. 5 A.
Fig. 6 A describes the example that user's replacement value style format of the daughter element of interactive table changes.
Fig. 6 B describes the interactive table of stretch-out view 6A to show the example of other daughter element.
Fig. 7 A describes the example to user's replacement value style format change of two child elements of interactive table.
Fig. 7 B describe to resequence example of the element that shows in the interactive table of Fig. 7 A.
Fig. 8 A describes to have the exemplary interactive table of default style formatting.
The interactive table that Fig. 8 B describes to get into Fig. 8 A is with the example of the daughter element of showing the father's element that in the interactive table of Fig. 8 A, shows.
The example that user's replacement value style format of the daughter element that shows in the interactive table of Fig. 8 C depiction 8B changes.
Fig. 8 D describes to fold the father's element that shows at first in the interactive table of interactive table with displayed map 8A of Fig. 8 C, and wherein these father's elements is made the change of user's replacement value style format.
The interactive table that Fig. 8 E describes to get into Fig. 8 D is with the example of the identical daughter element showed in the interactive table that is presented at Fig. 8 C.
Fig. 9 A, 9B and 9C illustration allow the element to interactive table to continue the embodiment of logic flow of the style User Format layout of existence.
Figure 10 illustration allows the element to interactive table to continue the embodiment of logic flow of the layout User Format layout of existence.
Figure 11 illustration allows the element to interactive table to continue the embodiment of logic flow of first disposition User Format layout of existence.
But Figure 12 is a process computer software is the block diagram of the exemplary basic computer system of program code or instruction.
Specify
In the following description, having set forth numerous details for purpose of explanation understands of the present invention so that provide fully.Yet it will be obvious to those skilled in the art that does not have these details can put into practice the present invention yet.In other instance, known structure and equipment are shown so that avoid unnecessarily obscuring the present invention with the block diagram form.
Interactive table, such as but be not limited to PivotTables, be the visualization tool of high flexible, they are used for through the graphics mode video data to convey a message concisely and to carry out IDA.Fig. 1 is an embodiment framework of supporting exemplary interactive table.One or more interactive table 100 such as but be not limited to the pivot chart can from form 105 such as but be not limited to interactive form for example PivotTables generate.Yet only a form 105 is associated with specific interactive table 100.In interactive table 100, be from 105 retrievals of its form that is associated through the graphics mode data presented.
One or more form 105 is created from data cache 110.Data cache 110 and then from its data of data source 115 retrieval.
If the data in data source 115 are modified, for example are added, delete or change, then relevant associated data in the refresh data high-speed cache 110.In one embodiment, also refresh the associated data that in corresponding form 105, shows.In an alternative embodiment, the data in the form 105 are only refreshed when the user asks as required.
In one embodiment, after the data in refreshing form 105, any interactive table 100 of changing as required based on this form 105 changes with the basis of reflection to described data.In an alternative embodiment, interactive table 100 only is modified during to any relevant the refreshing of its basic data in user request.
The various elements that in interactive table, show can in all sorts of ways formatting, to strengthen its aesthetic appeal and to help to realize data analysis efficiently.The element that comprises any chart of interactive table includes but not limited to, the bar of legend, label, data point, Trendline, bar chart, axle or the like.Fig. 2 describes three kinds of formatting types 200, and each type can be used for customizing the outward appearance of interactive table 100.In other embodiments, can use more, still less or replacement formatting type customize interactive table 100.
First kind of formatting type 200, or be color application and/or the visual effect that style format layout 210 refers to chart element.For example, presenting the style format layout when changing, the user can ask that a particular data point is colored as yellow and replace the blueness given tacit consent to, so that attract the notice to it, perhaps because other aesthetic feeling or analyze and strengthen reason.
As another example of style format layout 210, interactive table can show three bars 212,214 and 216, representes a data points separately.These three bars 212,214 and 216 have the default color of independent appointment separately.Assigned for leftmost 212 acquiescence red, middle bar 214 has assigned acquiescence blue, and rightmost 216 assigned acquiescence purple 218.The user can appear to these one of style format change, for example, it is colored as yellow but not the blueness of acquiescence through request for the bar 214 of centre.After such request, interactive table shows identical data point, but now, leftmost 212 keep its acquiescence red and rightmost 216 keep its acquiescence purple in, middle bar 218 is yellow that the user asks.
Second kind of Format Type 200, or be element personality formula layout 220, the existence of the element that refers in interactive table, to be shown.For example, adding legend to interactive table is a kind of element personality formula layout change.Exemplary histogram 222 is not drawn legend, and when the user asks, and histogram 224 shows the data point identical with histogram 222, also shows legend 226 in addition.
The third Format Type 200, or be layout format layout 230, refer to be presented at the placement of the element in the interactive table.For example, the user can present the layout format change from the upper left bottom right that is repositioned onto chart 236 of chart 234 through asking chart legend element 232.
In one embodiment, ask visual change or user's replacement value in interactive table 100, to continue to exist based on each user of this three Format Types 200.
In the example in front, to the visual change of interactive table, no matter being based on style format layout 210, element personality formula layout 220, layout format layout 230 still is its combination in any, causes that all current interactive table changes.After any change of format or any navigation to interactive table, interactive table is still original chart, but its view has changed to and shown contents more, lacked in some perhaps some different content.
In one embodiment, the formatting that the element of interactive table is used acquiescence, only if up to and user's request to the specific format change of chart element.Refer to be applied to acquiescently the formatting of DS in this serial formatting.DS is the classification of data.An example of DS is CA (California) DS 240 shown in Figure 2.Other example data series shown in Figure 2 is OR (Oregon) DS 242 and WA (Washington) DS 244.In one embodiment, serial default form layout relates to style, type and the whole style theme of chart.
In one embodiment, be that maximization is shown under the situation of the color distortion between the DS in target, the particular data series in default style formatting color assignment and the interactive table is irrelevant.In this embodiment, the color assignment of acquiescence is based on that colour switching in the specific interactive table style calculates.Thereby, in one embodiment, no matter be the change of supporting the basic data of interactive table, still various chart navigation for example get into, folding or expansion, assign the default color of giving the style format layout can not continue to exist.Thereby, in one embodiment, in interactive table, can, various charts change when navigating to keep the aesthetic feeling of chart with default style formatting data presented series.
With reference to figure 3A, exemplary interactive histogram 300 shows three state series CA (California) 302, OR (Oregon) 304 and the data point of WA (Washington) 306 three data field food 308, beverage 310 and nonexpendable item 312 separately or the default style formatting of element.In one embodiment, through calculating each DS 302,304 and 306 is carried out the default color appointment, this calculating has the Origin And Destination that is designed to maximize difference between the series 302,304 and 306.The color assignment of the style format layout of various DSs 302,304 and 306 element is based on the index of respective series.In exemplary interactive histogram 300; The data point 314,322 and 332 of CA state series 302 is bluenesss of acquiescence; OR state series 304 data points 316,324 and 334 are yellow of acquiescence, and WA state series 306 data points 318,326 and 336 are grey of acquiescence.
The interactive table 320 of Fig. 3 B is that the exemplary of interactive table 300 of Fig. 3 A folds.In this example, OR state series 304 is filtered, promptly OR state data point be not presented at Fig. 3 B interactive table in front view.In this embodiment, default style form color assignment does not continue to exist.It is blue that the CA state series 302 of interactive table 320 is kept its original default from interactive table 300, and the data point 342,344 and 346 of the WA state of interactive table 320 series 306 has been assigned acquiescence yellow again.In one embodiment, carrying out this default form assigns to maximize two differences between the series 302 and 306 of keeping demonstration again.
Continue the formatting of existence; Or be that form keeps, the user to various interactive map table elements when supporting to maintain the basic data that changes the support chart during the chart navigation or when for example adding by any way, delete or revising asks or the change of user's replacement value form.In one embodiment, all three Format Types 200 are that style format layout 210, the layout 220 of element personality formula and layout format layout 230 continue to exist.The user of interactive table can use the user-defined format layout on every interactive table basis.In one embodiment; Because exist an above interactive table 100 are the possibilities to form 105; Therefore each interactive table 100 keeps the user-defined format layout of its user's request, and is irrelevant with other interactive table 100 based on same form 105.
Fig. 4 A, 4B and 4C are exemplary interactive histograms, and promptly the replacement view of interactive histogram is wherein kept the formatting that continues existence for the change of user's replacement value style format.Each chart 400,410 and 420 is presented at the profit data point of the various consumer products of the U.S. (USA) purchase.In Fig. 4 A, exemplary interactive histogram 400 shows the data point of USA profit DS, and wherein three data field beverages 402, food 404 and nonexpendable item 406 acquiescences have been assigned blueness.The interactive histogram 410 of Fig. 4 B is the results that get into interactive post Figure 40 0, and wherein beverage data field 402 is replaced by three sub-data field carbonated drinks 412, fruit juice 414 and water 416.In one embodiment; Because the data point 401 of beverage father data field 402 is bluenesss of acquiescence; And do not have the user's replacement value change of format to this data field 402, so each data point 411,413 and 415 of subdata territory 412,414 and 416 also is assigned the blueness of acquiescence.
In one embodiment, the default style formatting is applied to father's data point of interactive table or the primitive rule of element is:
(if in chart, showing father's element) and (form is an acquiescence)
Father's element format=default form then
In one embodiment, the primitive rule that the default style formatting is applied to subnumber strong point or the element of interactive table is to be that daughter element is assigned the style format layout identical with his father's element:
(if in chart, showing daughter element) and (form is an acquiescence)
Daughter element form=father's element format=default form
With reference to figure 4C, interactive histogram 420 shows the data point identical with the interactive histogram of Fig. 4 B 410, but the user's replacement value style format with antithetical phrase data field is changed.Clearly, in the interactive histogram 410 of Fig. 4 B, the data point 413 in fruit juice subdata territory 414 is bluenesss of acquiescence.Yet in the interactive histogram 420 of Fig. 4 C, the data point 424 in fruit juice subdata territory 414 is that user-defined format is red now, obeys user's replacement value style format and changes request.All the other data presented points, his father and subdata territory all keep its acquiescence in interactive histogram 420 blue.
In one embodiment, user's replacement value style format change is applied to the subnumber strong point of interactive table or the primitive rule of element is:
(if in chart, showing daughter element) and (form is user's replacement value)
Daughter element form=user's replacement value form
In one embodiment, the data that identifying user replacement value style format changed directly are associated with the data tuple of association diagram element and index rule and are stored in.For exemplary interactive histogram 420, sign is asked the style format color change to the user of fruit juice data field 414 data are stored in the formatting array of interactive histogram 420 with the data tuple of its data point 424:
<beverage-fruit juice>< U.S.>< profit >=redness
If folding subsequently interactive histogram 420 makes beverage father data field 402 replace its subdata territory once more and is shown, the interactive histogram 400 of displayed map 4A once more then.In this example because the user not request to beverage father data field 402 the style format change, so its data point 401 shows with the acquiescence blueness of its original appointment once more.If the some time after the interactive histogram 402 of folding Fig. 4 C is the interactive histogram 400 of Fig. 4 A; Get into interactive table 400 once more to show three sub-data field carbonated drinks 412, fruit juice 414 and water 416 again, then the formatting of user's replacement value continues to exist.Thereby the data point 424 in fruit juice subdata territory 414 shows with user's replacement value redness again, shown in the interactive histogram 420 of Fig. 4 C.Because the user does not ask any style format in other subdata territory is changed; Therefore for father's data field food 404 and nonexpendable item 406 of carbonated drink 412 and water 416 or all the other demonstrations, each data point of these territories shows so that the acquiescence of its original appointment is blue.
In one embodiment; If the data point or the basic data source of element that are presented in the interactive table 420 are modified such as but not limited to adding, delete, refresh or upgrading, then the data point 424 in fruit juice subdata territory 414 keeps with its current user's replacement value red display that is assigned.
Fig. 5 A and 5B are extra exemplary interactive histograms, and promptly the replacement view of interactive histogram is wherein kept the formatting that continues existence for the change of user's replacement value style format.The interactive histogram 500 of Fig. 5 A and the interactive histogram 510 of Fig. 5 B all are presented at the profit data point of the various consumer products of the U.S. (USA) purchase.In Fig. 5 A, exemplary interactive table 500 shows U.S.'s profit data point series of three data fields, and wherein two data field food 504 are bluenesss that acquiescence is assigned with nonexpendable item 506, and a data field beverage 502 is that user's replacement value is red.
In one embodiment, the layout of user's replacement value style format is applied to father's data point of interactive table or the primitive rule of element is:
(if in chart, showing father's element) and (form is user's replacement value)
Father's element format=user's replacement value form
As previously mentioned, in one embodiment, the data that identifying user replacement value style format changes directly are associated with the data tuple of association diagram element and index rule and are stored in.For exemplary interactive histogram 500, sign is stored in the formatting array of interactive table 500 data of user's replacement value style format color change of beverage data field 502 data tuple with its data point 507:
<beverage>< U.S.>< profit >=redness
The interactive histogram 510 of Fig. 5 B is the results that get into the interactive histogram 500 of Fig. 5 A, and wherein beverage data field 502 is replaced by three sub-data field carbonated drinks 512, fruit juice 514 and water 516.In one embodiment; Because it is red that the data point 507 of the beverage father data field 502 of Fig. 5 A is user's replacement values; And the user to any three sub-data fields 512,514 or 516 does not ask change of format, so the data point 518,520 and 522 of each of these corresponding subdata territories also is user's replacement value redness.
In one embodiment, the primitive rule that the default style formatting is applied to subnumber strong point or the element of interactive table is to be that daughter element is assigned the style format layout identical with father's element:
(if in chart, showing daughter element) and (form is user's replacement value)
Daughter element form=father's element format=user's replacement value form
Thereby; In this embodiment; The default style formatting in subdata territory is not the original default style format layout that his father's data field is given in original appointment, shows that in interactive table the subnumber strong point is applied to user's replacement value style format change of father's element before but replace.
For exemplary interactive histogram 510, identify its corresponding data point 518,520 of data of the user's replacement value style format redness that is applied to subdata territory carbonated drink 512, fruit juice 514 and water 516 and 522 data tuple and be stored in together in the formatting array of interactive table 510:
<beverage-carbonated drink>< U.S.>< profit >=redness
<beverage-fruit juice>< U.S.>< profit >=redness
<beverage-water>< U.S.>< profit >=redness
Fig. 6 A and 6B also are the example interactive histograms, or are the replacement view of interactive histogram, wherein keep the formatting that continues existence for the change of user's replacement value style format.Interactive histogram 600 shows U.S.'s profit data point of three series California, state (CA) 602, Oregon (OR) 604 and Washington (WA) 606 and two beverage data fields carbonated drink 608 and water 610.In Fig. 6 A, all data presented points are bluenesss that acquiescence is assigned, and except the data point 612 of OR state series 604 carbonated drink data fields 608, it is that user's replacement value is red.The data of identifying user replacement value style format redness are stored in the data tuple of data point 612:
<beverage-carbonated drink>< Oregon>< U.S.>< profit >=redness
The interactive histogram 620 of Fig. 6 B is the results that comprise an extra codomain, comprises that promptly the same display data source is the excessive data territory of DS CA 602, OR 604 and WA 606 and the data field carbonated drink 608 and the water 610 of the interactive histogram 600 of Fig. 6 A.In this example, the additional data point that is used for cost is presented at the interactive table 620 of Fig. 6 B, together with the original profit data point that shows in the interactive table 600 of Fig. 6 A.Cost data territory 624 is not the daughter element of the profit data field 626 that is pre-existing in, but fraternal element.Thereby the cost data point 622 of state, Oregon series 604 carbonated drink data fields 608 does not have to adopt user's replacement value style format of the profit data point 612 that is applied to state, same Oregon series 604 carbonated drink data fields 608 red.But Oregon carbonated drink cost data point 622 has been assigned the blueness of acquiescence, and this is meant the original default color of tasking state, Oregon series 604 beverage data fields.Yet, add cost data point to interactive table 620 and do not change user's replacement value style format redness of assigning to Oregon carbonated drink profit data point 612.
Fig. 7 A and 7B are interactive histograms, or are the replacement view of interactive histogram, and the formatting that wherein when rearrangement chart numbers strong point or element, continues to exist is maintained.The interactive histogram 700 of Fig. 7 A shows that three series California, state (CA) 702, Oregon (OR) 704 and Washington (WA) 706 have U.S.'s profit data point of two beverage data field carbonated drinks 708 and water 710 separately.In Fig. 7 A, all data presented points are bluenesss that acquiescence is assigned, except the data point 712 and 714 of state, California series 702.California carbonated drink profit data point 712 is that user's replacement value style format is red, and California water conservancy profit data point 714 is that user's replacement value style format is green.The data that identify these user's replacement value style formats are stored in the corresponding data tuple of California data point 712 and 714:
<beverage-carbonated drink>< California>< U.S.>< profit >=redness
<beverage-water>< California>< U.S.>< profit >=green
The interactive histogram 720 of Fig. 7 B is to the data point of the interactive histogram 700 of Fig. 7 A or the result that element is resequenced.In interactive histogram 700, press beverage sorting data point again by the state.By contrast, in the interactive histogram 720 of Fig. 7 B, press beverage again by state sorting data point.In one embodiment, with the formatting to the lasting existence of interactive table, when data point that rearrangement is shown, they assign the style format layout of giving them before remaining on rearrangement.Thereby; In interactive histogram 720; The blueness that Oregon and State of Washington beverage (carbonated drink and water) profit data point 716,718,722 and 724 keeps its acquiescence to assign; And California carbonated drink profit data point 712 keeps its user's replacement value red, and California water conservancy profit data point 714 keeps its user's replacement value green.
Fig. 8 A, 8B, 8C, 8D and 8E are interactive histograms; Or be the replacement view of interactive histogram, the formatting that wherein when the layout of user's replacement value style format being applied to subnumber strong point or element and being applied to various father's data points or element subsequently, continues to exist is kept.The interactive histogram 800 of Fig. 8 A shows each the profit data point of U.S.'s series of beverage data field 802, food data territory 804 and nonexpendable item data field 806.The data point or the element 803,805 and 807 of each U.S.'s series that is shown in this example, are the bluenesss that acquiescence is assigned.
The interactive histogram 810 of Fig. 8 B is the results that get into interactive histogram 800, and wherein the beverage father data field 802 of Fig. 8 A is replaced by subdata territory carbonated drink 812, fruit juice 814 and water 816.Because the data point 803 of beverage father data field 802 is bluenesss that acquiescence is assigned; And do not have the request of user's replacement value style format, so the data point 811,813 and 815 of the corresponding subdata territory 812,814 of interactive table 810 and 816 is also all assigned the blueness of acquiescence.
The interactive histogram 820 of Fig. 8 C shows the data point identical with the interactive table of Fig. 8 B, except fruit juice profit subnumber strong point 822 in interactive table 820 is red now, submits to user's replacement value style format and changes request.The red data of identifying user replacement value are stored with the data tuple of fruit juice profit data point or element 822:
<beverage-fruit juice>< U.S.>< profit >=redness
In Fig. 8 D; Interactive histogram 830 is results of the interactive histogram 820 of folding Fig. 8 C; The profit data point 832 that wherein shows beverage father data field 802 is to replace corresponding subnumber strong point 811 (carbonated drink profit), 822 (fruit juice profits) and 815 (water conservancy profit).In addition; In interactive histogram 830; Serial grade formatting user replacement value has been arranged, thus each data presented of U.S. series select 832 (beverage profits), 834 (food profits) and 836 (nonexpendable item profits) be user's replacement value style format green now.The data of the data point of sign U.S. series or user's replacement value style format change of element 832,834 and 836 are stored with the corresponding data tuple of each data point:
<beverage>< U.S.>< profit >=green
< food>< U.S.>< profit >=green
< nonexpendable item>< U.S.>< profit >=green
The interactive histogram 840 of Fig. 8 E is the results that get into the interactive histogram 830 of Fig. 8 D subsequently.In interactive table 840, subnumber strong point 842 (carbonated drink profit), 822 (fruit juice profits) and 846 (water conservancy profit) replace the beverage profit father data point 832 of interactive table 830.In addition, in interactive table 840, subnumber strong point 848 (meat profit) and 850 (agricultural product profits) replace the food profit father data point 834 of interactive table 830.In this example, nonexpendable item profit father data point 836 keeps in interactive table 840 and its demonstration identical in interactive table 830, or promptly green with user's replacement value.
Because fruit juice profit subnumber strong point 822 had before assigned user's replacement value red, so keep when in interactive histogram 840, showing again should redness for it.The style format of employing and its beverage profit father data point 832 is continued with water conservancy profit subnumber strong point 846 in carbonated drink profit subnumber strong point 842, because all do not have user's replacement value to change request for the arbitrary of these elements.As previously mentioned, in one embodiment, the primitive rule that the default style formatting is applied to subnumber strong point or the element of interactive table is to be that daughter element is assigned the style format layout identical with his father's data point or element:
(if in chart, showing daughter element) and (form is user's replacement value)
Daughter element form=father's element format=user's replacement value form
Thereby in current example, carbonated drink profit subnumber strong point 842 is colored as green separately with water conservancy profit subnumber strong point 846, promptly is applied to user's series replacement value style format color of beverage profit father data point 832 in its interactive table 830.Sign is applied to now its corresponding data tuple of data that user's replacement value style format of in interactive table 840 data presented point 842 and 846 changes and stores together:
<beverage-carbonated drink>< U.S.>< profit >=green
<beverage-water>< U.S.>< profit >=green
Store with the corresponding data tuple of this daughter element when in one embodiment, the data of identifying user replacement value change of format show the daughter element of taking this change of format for the first time in interactive table.Thereby in current example, store with the green data its corresponding data tuple when these data points 842 and 846 show in interactive table 840 for the first time of the style format at water conservancy profit subnumber strong point 846 together at sign carbonated drink profit subnumber strong point 842.In this embodiment; Identify these subnumber strong points 842 and 846 each green data of style format do not have its corresponding data tuple to store together when the user asks the style format of this U.S.'s series to change, because these subnumber strong points 842 are not presented in the interactive table 830 with 846 at this moment.
In an alternative embodiment, the data of identifying user replacement value change of format corresponding data tuple with the daughter element of taking change of format when the user makes the change of format request is for the first time stored.Thereby; In this alternative embodiment; And its corresponding data tuple was stored together when reference example interaction formula histogram 840, the green data of sign carbonated drink profit subnumber strong point 842 and the style format at water conservancy profit subnumber strong point 846 were made this change of format request to U.S.'s series the user.
Refer again to the interactive histogram 840 of Fig. 8 E; The style format of the food profit father data point 834 of its interactive table 830 is taked with agricultural product profit subnumber strong point 850 in meat profit subnumber strong point 848, because user's replacement value change of any of these element is not asked.In one embodiment, the primitive rule that the default style formatting is applied to subnumber strong point or the element of interactive table is to be that daughter element is assigned the style format layout identical with his father's element.Sign is applied to the green its corresponding data tuple of data of user's replacement value of the present subnumber strong point 848 that in interactive histogram 840, shows and 850 and stores together:
< food-meat>< U.S.>< profit >=green
< food-agricultural product>< U.S.>< profit >=green
Fig. 9 A, 9B and 9C illustration are kept the logic flow embodiment of method that continues to exist user's replacement value style format change that is used for interactive map table element or data point.Make following discussion although be relevant to system described here, can realize described operation in other systems.And, the order shown in operation described here is not limited to.In addition, in other alternative embodiment, can carry out more or less operation.
In the time in interactive table, will showing a child elements, confirm the default style form 900 of this chart element.When in interactive table, showing this chart element, just be applied to this chart element 905 to this default form.At decision box 910, be made in the judgement that whether will show another chart element in the current interactive table.If make then whether the new element that will show is the judgement 915 of the daughter element of existing chart father element.If the default form of this father's element is applied to the new daughter element 920 that this will show.If not, the daughter element that promptly new chart element is not existing chart element is then confirmed the default style form 900 of this new chart element, and when in interactive table, showing, default form is applied to this chart element 905.
Whether other element is current will add to if confirm not have, or promptly is presented in the interactive table, then make the user in decision 925 and asked one or more daughter element to replace the i.e. judgement of folding chart by its corresponding father's element.If when in interactive table, showing, be applied to each such father's element for the form of father's element Current Delegations.The form of this current appointment can be before definite and assign the default form of giving corresponding father's element.Replacedly, the form of this current appointment can be the user's replacement value form that before when the user asks, is applied to father's element, and is as further described below.
If the user does not ask to replace one or more daughter element, then make the judgement 935 whether user asks to show fewer father's elements, this also is a kind of method of folding interactive table.If keep the previous user's replacement value form 940 of giving any existing chart element that will show of assigning.For these chart elements that do not have user's replacement value form, confirm and assign the default form 945 of chart element.Then, no matter be the form that user's replacement value form or acquiescence are assigned, each chart element 950 that the form of Current Delegations is applied in interactive table, show.
In the said embodiment of Fig. 9 A; Confirming default form 945 and using 950 is the daughter element of demonstration still after father's element no longer shows in interactive table in filtering out one or more father's element, if these daughter elements had not before been assigned user's replacement value form.In this embodiment, user's replacement value form of before having assigned is applied to after one or more father's element no longer is presented in the interactive table, still keep the daughter element 940 of demonstration.Yet, in this embodiment, when daughter element continues in interactive table, to show, can confirm its new default form.Basically; In this embodiment; If keep father's element of the daughter element of demonstration when one or more other father's element no longer shows, still to show, if this father's element is assigned the default style form again, the daughter element that then keeps showing is assigned the default style form that gives his father's element again.
In an alternative embodiment, with the form of Current Delegations, no matter be acquiescence or user's replacement value form, be applied to any daughter element that after filtering out or promptly no longer showing one or more father's element, in interactive table, still shows.In this alternative embodiment,, daughter element do not have to confirm new default form when continuing in interactive table, to show for it.If any such daughter element was not also assigned user's replacement value form, then it continues to show with the default form of its Current Delegations.
If the user does not ask to show fewer father's elements, then make the judgement whether user asks to show in interactive table fewer daughter elements in decision 955, this is the additional method of folding interactive table.If, no matter be that user's replacement value form or acquiescence are assigned form, each chart element 950 that is applied in interactive table, show then with the form of Current Delegations.
If the user is the folding interactive table of request not, perhaps fold and navigated, then in the decision 960 of Fig. 9 B, make the judgement whether request of user's replacement value change of format is arranged.If confirm whether the user asks the change of format 965 of father's element.If the data of identifying user replacement value formatted request store 970 with the data tuple of father's element, and when in interactive table, showing, user's replacement value form is applied to this father's element 975.
If the user asks replacement value change of format, but not to father's element, then change is to be directed against daughter element.The data of identifying user replacement value formatted request store 980 with the data tuple of daughter element, and when in interactive table, showing, user's replacement value form are applied to daughter element 985.
In decision 990, make the user and whether ask the folding judgement of chart, one or more daughter element makes its corresponding father's element be shown, the father's element of some is shown or lacks some daughter elements and is shown less such as but not limited to launching.If, do not make the judgement whether user asks to show daughter element at the decision block 995 of Fig. 9 C.If before whether make the judgement of the daughter element that user's replacement value form is applied to show in decision 1015.If then when in interactive table, showing, user's replacement value form is applied to daughter element 1020.Otherwise,, before whether make the judgement of father's element of the daughter element that user's replacement value form is applied to show in decision 1025.If the data that sign are applied to user's replacement value form of father's element store 1030 with the data tuple of daughter element, and when in interactive table, showing, father's element user replacement value form is applied to daughter element 1035.Yet,, father's element format of Current Delegations is applied to daughter element 1035 if before user's replacement value form be not applied to father's element of daughter element.
In one embodiment, if the user asks to show daughter element,, then make the judgement 995 whether user asks to show daughter element once more in case this daughter element is shown.Thereby, in this embodiment, all daughter elements that user's request shows are simultaneously carried out processing.
If do not show user's request of daughter element, perhaps current daughter element shows asks all to have handled, and then makes the judgement 1000 whether user asks to show father's element.If, make the judgement that before whether had shown father's element that will show in decision 1010.If then when in interactive table, showing, the form of its Current Delegations is applied to this father's element 1005.The form of this current appointment can be before definite and assign the default form of giving corresponding father's element.Replacedly, this Current Delegations form can be the user's replacement value form that before when the user asks, is applied to father's element.
If confirm that in decision 1010 father's element that will show did not before show; Or be that it is the new chart element that adds interactive table to; Then confirm the default form 1040 of this father's element, and when in interactive table, showing, default form is applied to this father's ekahafnium 5.
In one embodiment, if the user asks to show father's element,, then make the judgement 1000 whether user asks to show father's element once more in case this father's element is shown.Thereby, in this embodiment, all father's elements that user's request shows are simultaneously carried out processing.
Figure 10 illustration is kept the logic flow embodiment of method that continues to exist user's replacement value layout format change of interactive map table element.Make following discussion although be relevant to system described here, said operation can realize in other systems.And operation described here is not limited to described order.In addition, in other alternative embodiment, can carry out more or less operation.
In the time a chart element will in interactive table, being shown, confirm the default form 1100 of this chart element.When in interactive table, showing, this default form is applied to this chart element 1105 subsequently.In decision 1110, make the judgement that whether will in interactive table, show another chart element.If confirm the default form 1100 of this new chart element, and when in interactive table, showing, default form be applied to this chart element 1105.Yet,, make the judgement 1115 whether user asks the replacement value layout format of chart element to change if current do not have other chart element will add interactive table to.If, the data of identifying user replacement value formatted request are stored 1120 with the data tuple of this chart element, and when in interactive table, showing this chart element with user's replacement value form be applied to it 1125.
Figure 11 illustration is kept the logic flow embodiment of method that continues to exist user's replacement value element personality formula change of interactive map table element.Make following discussion although be relevant to said system, can realize described operation in other systems.And, the order shown in said operation is not limited to.In addition, in other alternative embodiment, can carry out more or less operation.
At decision block 1150, make the judgement whether user asks Singapore dollar disposition chart element, such as but not limited in interactive table, adding and displayed map chart example.If, for Singapore dollar disposition chart element produces data tuple 1155.Confirm the default form 1160 of this Singapore dollar disposition chart element, and when in interactive table, showing, default form is applied to this chart element 1165.
In decision 1170, make the judgement whether user asks the element personality formula change of chart element.If the data that identifying user replacement value element personality formula changes are stored 1175 with the data tuple of this chart element, and when in interactive table, showing, user's replacement value form are applied to this yuan disposition chart element 1180.
Computer system configurations
Figure 12 is the block diagram that wherein can realize the exemplary computer system 1200 of embodiment.Computer system 1200 comprises bus 1205 or other mechanism that is used for the communication information, and be used for process information with bus 1205 coupled processing units 1210.Computer system 1200 also comprises system storage 1215, and it can be a volatibility or dynamically such as random-access memory (ram), also can be non-volatile or static such as ROM (read-only memory) (ROM) or flash memory, perhaps can be both certain combinations.System storage 1215 is coupled to bus 1205 and is used to store the information and instruction of being carried out by processing unit 1210, and can be used for being stored in temporary variable or other intermediate information by during processing unit 1210 execution commands.System storage 1215 comprises operating system and one or more program usually, and comprises routine data.
In one embodiment, memory device 1220 also is coupled to bus 1205 like magnetic or CD and is used for canned data, comprising comprising instruction and/or data at interior program code.
Computer system 1200 generally comprises one or more display device 1235, such as but be not limited to display screen for example cathode ray tube (CRT) or LCD (LCD), printer and one or more loudspeaker, be used for information being provided to the computer user.Computer system 1200 generally also comprises one or more input equipment 1230; Such as but be not limited to keyboard, mouse, trace ball, pen, voice-input device and touch input device, the computer user can use them that information and command selection are communicated to processing unit 1210.All these equipment are known in this area and needn't detail at this.
Processing unit 1210 is carried out one or more sequence that is included in one or more programmed instruction in the system storage 1215.These instructions can be from comprising but are not limited to read in the system storage 1215 other computer-readable medium of memory device 1220.In alternative embodiment, can replace software program instructions to use the hard-wired circuitry system, or combine software program instructions to use.Thereby computing system environments is not limited to any particular combination of ware circuit and software.
Refer to participate in any medium of providing programmed instruction to be used to carry out to processing unit 1210 at the term " computer-readable medium " of this use.Such medium can adopt many forms, includes but not limited to storage medium and transmission medium.The example of storage medium includes but not limited to; RAM, ROM, EEPROM, flash memory, CD-ROM, digital versatile disc (DVD), tape cassete, tape, disk storage or any other magnetic medium; Floppy disk, movable disk, punched card, paper tape or have any other physical medium, memory chip or the cartridge of sectional hole patterns.The system storage 1215 and the memory device 1220 of computer system 1200 are other examples of storage medium.The example of transmission medium includes but not limited to wired media such as concentric cable and copper cash, and wireless medium such as fiber-optic signal, acoustic information, RF signal and infrared signal.
Computer system 1200 comprises that also one or more communication of being coupled to bus 1205 connects 1250.Communication connect 1250 provide from computer system 1200 be coupled to Local Area Network 1265 and/or comprise the WWW or the wide area network of the Internet (WAN) 1270 on other computer system and/or the bidirectional data communication of computing equipment.The example of communication connection 1250 includes but not limited to integrated service digital network (ISDN) card, modulator-demodular unit, LAN card and any equipment that can send and receive electricity, electromagnetism, light, sound, RF or infrared signal.
The communication that is received by computer system 1200 can comprise programmed instruction and routine data.The programmed instruction that computer system 1200 receives can be carried out when receiving them by program element 1210, and/or be stored in be used in memory device 1200 or other non-volatile memories after execution.
Sum up
Although described various embodiment at this, these embodiment only provide as an example, and do not answer the scope of requirement for restriction protection theme.The interior many variants of scope that remain on accompanying claims are possible.These variants are clearly after examination detailed description, accompanying drawing and claim here.Therefore, require the extension of protection theme and the restriction that scope only receives accompanying claims and equivalents thereof.

Claims (18)

1. the method for the chart element of an interactive table that formatting is applied to show to computer system user; Said interactive table comprises first chart element and second chart element; Said second chart element is made up of the daughter element of said first chart element, and said method comprises:
Select said first chart element of default form to be applied in said interactive table, show;
Reception is applied to the first replacement value form request of said first chart element at least; And
After receiving the request of using the said first replacement value form:
When showing that when folding said interactive table does not show said second chart element to show said first chart element, the said first replacement value form is applied to said first chart element; And
If do not receive the request that the second replacement value form is applied to said second chart element, when showing that non-said interactive table when showing said second chart element, is applied to said second chart element with the said first replacement value form when folding; And
If receive the request that the second replacement value form is applied to said second chart element, when showing that non-said interactive table when showing said second chart element, is not applied to said second chart element with the said first replacement value form when folding.
2. the method for claim 1, said interactive table comprises the pivot chart.
3. method as claimed in claim 2:
Said pivot chart produces from interactive form,
Said interactive form is set up from data cache, and
The data creation of said data cache from data source.
4. method as claimed in claim 3; Said default form is to be applied to said first chart element on style, to distinguish the default style form of said first chart element and the 3rd chart element; Said first chart element obtains from first DS from said data source, and said the 3rd chart element obtains from second DS from said data source.
5. the method for claim 1; Said interactive table is from the data creation from data source, and said method is included in that data from said data source are modified and the said first replacement value form is applied to said first chart element said when in the interactive table that computer system user shows, showing said first chart element.
6. the method for claim 1, said first chart element comprise with its data tuple that is associated and the data that will identify the said first replacement value form and defining with the data tuple that is associated with said first chart element.
7. the method for claim 1 comprises, receive the said first replacement value form is applied to the request of said first chart element at least before, said default form is applied to said second chart element.
8. the method for the chart element of an interactive table that formatting is applied to show to computer system user; Said interactive table comprises: first chart element and second chart element; The daughter element of said first chart element of said second chart element, said method comprises:
Default form is applied to said first chart element:
Said default form is applied to said second chart element;
Reception is worth the request that form is applied to said second chart element with replacement; And
After receiving the request of using said replacement value form:
When showing that when folding said interactive table does not show said second chart element to show said first chart element, said default form is applied to said first chart element, and
When showing that non-said interactive table when showing said second chart element, is applied to said second chart element with said replacement value form when folding.
9. method as claimed in claim 8, said interactive table comprises the pivot chart.
10. method as claimed in claim 8; Said interactive table is from the data creation from data source, and said method is included in that said data source is modified and said second chart element is applied to said second chart element with said replacement value form said when in the interactive table that computer system user shows, showing.
11. method as claimed in claim 8 comprises:
Reception is applied to the second replacement value form request of said first chart element; And
After receiving the request of using the said second replacement value form:
When showing that when folding said interactive table when showing said first chart element, replaces said default form to be applied to said first chart element said second replacement value form.
12. method as claimed in claim 8 receives the request that said replacement value form is applied to said second chart element and comprises the request that receives the style format change that changes said second chart element.
13. method as claimed in claim 11; Be included in to receive the said second replacement value form is applied to after the request of said first chart element; When said replacement value form being applied to said second chart element; The said second replacement value form is applied to the 3rd chart element, and said the 3rd chart element is the daughter element of said first chart element.
14. the method for the chart element of an interactive table that formatting is applied to show to computer system user; Said interactive table comprises: first chart element and second chart element; Said second chart element is the daughter element of said first chart element; Said chart element respectively obtains since data source, and said method comprises:
Default form is applied to said first chart element;
Select said default form to be applied to said second chart element; And
When receiving the change of format that is directed against the said default form that is applied to said first chart element:
If when said default form is not replaced from said user's the request that user's replacement value form is applied to said second chart element, the said change of format that is applied to said second chart element is applied to said default form; And
If when said default form was replaced from said user's the request that said user's replacement value form is applied to said second chart element, the said change of format that will not be applied to said second chart element was applied to said default form.
15. method as claimed in claim 14, said interactive table comprises the pivot chart.
16. method as claimed in claim 15, said pivot chart produces from interactive form, and said interactive form produces from data cache, and said data cache produces from said data source.
17. method as claimed in claim 14; Before receiving said change of format; In the interactive table that computer system user shows, no longer do not show but said second chart element when in the interactive table that computer system user shows, showing, is applied to said second chart element with said default form said said cannot being included in foldingly said interactive table and said first chart element.
18. method as claimed in claim 14 comprises:
Receive the request that said replacement value form is applied to said second chart element from said user;
Data with the said replacement value of the said data tuple storaging mark form of said second chart element; And
When said user shows said interactive table:
Said change of format is applied to said first chart element;
Data from the said replacement value of the said data tuple searching mark form of said second chart element; And
Said replacement value form is applied to said second chart element.
CN2006800456465A 2005-12-05 2006-12-05 Persistent formatting for interactive charts Active CN101322119B (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US11/294,038 2005-12-05
US11/294,038 US7961188B2 (en) 2005-12-05 2005-12-05 Persistent formatting for interactive charts
PCT/US2006/046467 WO2007067580A1 (en) 2005-12-05 2006-12-05 Persistent formatting for interactive charts

Publications (2)

Publication Number Publication Date
CN101322119A CN101322119A (en) 2008-12-10
CN101322119B true CN101322119B (en) 2012-10-10

Family

ID=38118221

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2006800456465A Active CN101322119B (en) 2005-12-05 2006-12-05 Persistent formatting for interactive charts

Country Status (4)

Country Link
US (3) US7961188B2 (en)
KR (1) KR101365877B1 (en)
CN (1) CN101322119B (en)
WO (1) WO2007067580A1 (en)

Families Citing this family (83)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070126731A1 (en) * 2005-12-06 2007-06-07 Sabram Stephen R Graphical architecture for handheld measurement system
US8301277B2 (en) * 2006-06-07 2012-10-30 Jones David D Dynamic display of a game spread
US7522176B2 (en) * 2006-11-14 2009-04-21 Microsoft Corporation Dynamically generating mini-graphs to represent style and template icons
US8024651B1 (en) * 2007-01-30 2011-09-20 Adobe Systems Incorporated Data visualization using tables integrated with hierarchical pie charts
US9058316B2 (en) * 2007-08-24 2015-06-16 International Business Machines Corporation System and method for annotation of data visualizations
US8127223B2 (en) * 2008-01-23 2012-02-28 Mellmo Inc. User interface method and apparatus for data from data cubes and pivot tables
US8560969B2 (en) * 2008-06-26 2013-10-15 Landmark Graphics Corporation Systems and methods for imaging operations data in a three-dimensional image
US8271892B2 (en) * 2008-07-02 2012-09-18 Icharts, Inc. Creation, sharing and embedding of interactive charts
US8520000B2 (en) * 2008-07-02 2013-08-27 Icharts, Inc. Creation, sharing and embedding of interactive charts
US8176096B2 (en) * 2008-12-18 2012-05-08 Microsoft Corporation Data visualization interactivity architecture
US8286081B2 (en) * 2009-04-30 2012-10-09 Apple Inc. Editing and saving key-indexed geometries in media editing applications
US9477933B2 (en) * 2009-10-13 2016-10-25 Sap Se System and method for graphical representation of business documents and effectivity
KR100969656B1 (en) * 2009-10-30 2010-07-14 (주)비아이매트릭스 An excel-based composing system for analyzing reports or views and the method thereof
US9007376B2 (en) * 2010-03-29 2015-04-14 Casio Computer Co., Ltd. Graph display apparatus and graph display method
US20120102419A1 (en) * 2010-10-22 2012-04-26 Microsoft Corporation Representing data through a graphical object
US9621406B2 (en) 2011-06-30 2017-04-11 Amazon Technologies, Inc. Remote browsing session management
US8577963B2 (en) 2011-06-30 2013-11-05 Amazon Technologies, Inc. Remote browsing session between client browser and network based browser
US8706860B2 (en) 2011-06-30 2014-04-22 Amazon Technologies, Inc. Remote browsing session management
US8799412B2 (en) 2011-06-30 2014-08-05 Amazon Technologies, Inc. Remote browsing session management
US9037696B2 (en) 2011-08-16 2015-05-19 Amazon Technologies, Inc. Managing information associated with network resources
US9195768B2 (en) 2011-08-26 2015-11-24 Amazon Technologies, Inc. Remote browsing session management
US10089403B1 (en) 2011-08-31 2018-10-02 Amazon Technologies, Inc. Managing network based storage
US10693991B1 (en) 2011-09-27 2020-06-23 Amazon Technologies, Inc. Remote browsing session management
US9178955B1 (en) 2011-09-27 2015-11-03 Amazon Technologies, Inc. Managing network based content
US9298843B1 (en) 2011-09-27 2016-03-29 Amazon Technologies, Inc. User agent information management
US9383958B1 (en) 2011-09-27 2016-07-05 Amazon Technologies, Inc. Remote co-browsing session management
US9641637B1 (en) 2011-09-27 2017-05-02 Amazon Technologies, Inc. Network resource optimization
US8914514B1 (en) 2011-09-27 2014-12-16 Amazon Technologies, Inc. Managing network based content
US9152970B1 (en) 2011-09-27 2015-10-06 Amazon Technologies, Inc. Remote co-browsing session management
US8589385B2 (en) 2011-09-27 2013-11-19 Amazon Technologies, Inc. Historical browsing session management
US8849802B2 (en) 2011-09-27 2014-09-30 Amazon Technologies, Inc. Historical browsing session management
US8615431B1 (en) 2011-09-29 2013-12-24 Amazon Technologies, Inc. Network content message placement management
US9122665B2 (en) 2011-10-10 2015-09-01 Microsoft Technology Licensing, Llc Rich formatting for a data label associated with a data point
US9313100B1 (en) 2011-11-14 2016-04-12 Amazon Technologies, Inc. Remote browsing session management
US9633110B2 (en) * 2011-11-15 2017-04-25 Microsoft Technology Licensing, Llc Enrichment of data using a semantic auto-discovery of reference and visual data
US8972477B1 (en) 2011-12-01 2015-03-03 Amazon Technologies, Inc. Offline browsing session management
US9117002B1 (en) 2011-12-09 2015-08-25 Amazon Technologies, Inc. Remote browsing session management
US9009334B1 (en) 2011-12-09 2015-04-14 Amazon Technologies, Inc. Remote browsing session management
US9330188B1 (en) 2011-12-22 2016-05-03 Amazon Technologies, Inc. Shared browsing sessions
US9087024B1 (en) 2012-01-26 2015-07-21 Amazon Technologies, Inc. Narration of network content
US9336321B1 (en) 2012-01-26 2016-05-10 Amazon Technologies, Inc. Remote browsing and searching
US8839087B1 (en) 2012-01-26 2014-09-16 Amazon Technologies, Inc. Remote browsing and searching
US9092405B1 (en) 2012-01-26 2015-07-28 Amazon Technologies, Inc. Remote browsing and searching
US9509783B1 (en) 2012-01-26 2016-11-29 Amazon Technlogogies, Inc. Customized browser images
US8627195B1 (en) * 2012-01-26 2014-01-07 Amazon Technologies, Inc. Remote browsing and searching
US9183258B1 (en) 2012-02-10 2015-11-10 Amazon Technologies, Inc. Behavior based processing of content
US9037975B1 (en) 2012-02-10 2015-05-19 Amazon Technologies, Inc. Zooming interaction tracking and popularity determination
US9137210B1 (en) 2012-02-21 2015-09-15 Amazon Technologies, Inc. Remote browsing session management
US9208316B1 (en) 2012-02-27 2015-12-08 Amazon Technologies, Inc. Selective disabling of content portions
US9374244B1 (en) 2012-02-27 2016-06-21 Amazon Technologies, Inc. Remote browsing session management
US10296558B1 (en) 2012-02-27 2019-05-21 Amazon Technologies, Inc. Remote generation of composite content pages
US9460220B1 (en) 2012-03-26 2016-10-04 Amazon Technologies, Inc. Content selection based on target device characteristics
US9307004B1 (en) 2012-03-28 2016-04-05 Amazon Technologies, Inc. Prioritized content transmission
US9501849B2 (en) * 2012-05-11 2016-11-22 Vmware, Inc. Multi-dimensional visualization tool for browsing and troubleshooting at scale
JP2014010801A (en) * 2012-07-03 2014-01-20 Casio Comput Co Ltd Histogram display device and program
US9772979B1 (en) 2012-08-08 2017-09-26 Amazon Technologies, Inc. Reproducing user browsing sessions
US8943197B1 (en) 2012-08-16 2015-01-27 Amazon Technologies, Inc. Automated content update notification
US9578137B1 (en) 2013-06-13 2017-02-21 Amazon Technologies, Inc. System for enhancing script execution performance
US10152463B1 (en) 2013-06-13 2018-12-11 Amazon Technologies, Inc. System for profiling page browsing interactions
US20150088925A1 (en) * 2013-09-20 2015-03-26 Oracle International Corporation User interface for pivot views
US10691872B2 (en) * 2014-03-19 2020-06-23 Microsoft Technology Licensing, Llc Normalizing message style while preserving intent
US9635041B1 (en) 2014-06-16 2017-04-25 Amazon Technologies, Inc. Distributed split browser content inspection and analysis
CN105426368B (en) * 2014-09-03 2020-07-07 腾讯科技（北京）有限公司 Information display method and device and electronic equipment
US9996955B2 (en) * 2014-09-23 2018-06-12 Salesforce.Com, Inc Analytics visualization
US9747711B2 (en) 2014-09-23 2017-08-29 International Business Machines Corporation Display of graphical representations of legends in virtualized data formats
US11488086B2 (en) * 2014-10-13 2022-11-01 ServiceSource International, Inc. User interface and underlying data analytics for customer success management
JP6511860B2 (en) * 2015-02-27 2019-05-15 富士通株式会社 Display control system, graph display method and graph display program
US10534522B2 (en) * 2015-03-30 2020-01-14 Sap Se Pinning portions of data visualizations
US9665654B2 (en) 2015-04-30 2017-05-30 Icharts, Inc. Secure connections in an interactive analytic visualization infrastructure
US10044577B2 (en) * 2015-11-04 2018-08-07 International Business Machines Corporation Visualization of cyclical patterns in metric data
US10049475B2 (en) 2015-12-14 2018-08-14 Microsoft Technology Licensing, Llc Utilizing selective triggering events for optimizing chart visualization
US10748312B2 (en) * 2016-02-12 2020-08-18 Microsoft Technology Licensing, Llc Tagging utilizations for selectively preserving chart elements during visualization optimizations
US10347017B2 (en) * 2016-02-12 2019-07-09 Microsoft Technology Licensing, Llc Interactive controls that are collapsible and expandable and sequences for chart visualization optimizations
US10331302B1 (en) * 2016-11-18 2019-06-25 Ipreo Llc Graphical user interface to track dynamic data
US11048386B2 (en) 2016-11-18 2021-06-29 Ipreo Llc Graphical user interface to track dynamic data
US10726095B1 (en) 2017-09-26 2020-07-28 Amazon Technologies, Inc. Network content layout using an intermediary system
US10664538B1 (en) 2017-09-26 2020-05-26 Amazon Technologies, Inc. Data security and data access auditing for network accessible content
US10895972B1 (en) * 2018-04-20 2021-01-19 Palantir Technologies Inc. Object time series system and investigation graphical user interface
US10902654B2 (en) 2018-04-20 2021-01-26 Palantir Technologies Inc. Object time series system
US11030255B1 (en) * 2019-04-01 2021-06-08 Tableau Software, LLC Methods and systems for inferring intent and utilizing context for natural language expressions to generate data visualizations in a data visualization interface
US10896480B1 (en) * 2019-09-23 2021-01-19 International Business Machines Corporation Visualization rendering using an extensible rendering sequence
CN110888673B (en) * 2019-12-02 2023-04-07 北京明略软件系统有限公司 Configuration interface configuration method, layout method and storage medium
CN112131845A (en) * 2020-08-27 2020-12-25 北京云动智效网络科技有限公司 PPT data chart making method and equipment

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5894311A (en) * 1995-08-08 1999-04-13 Jerry Jackson Associates Ltd. Computer-based visual data evaluation
CN1609853A (en) * 2003-06-13 2005-04-27 微软公司 Context association diagram for computer system architecture
CN1695107A (en) * 2002-09-27 2005-11-09 卡西欧计算机株式会社 Graphic display control device for displaying graph and graphic and recording medium

Family Cites Families (23)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5461708A (en) * 1993-08-06 1995-10-24 Borland International, Inc. Systems and methods for automated graphing of spreadsheet information
EP0736203A1 (en) * 1993-12-23 1996-10-09 Diacom Technologies, Inc. Method and apparatus for implementing user feedback
JP3361594B2 (en) * 1994-01-04 2003-01-07 富士通株式会社 Method and apparatus for setting / changing graph creation
US5619631A (en) * 1995-06-07 1997-04-08 Binaryblitz Method and apparatus for data alteration by manipulation of representational graphs
US6014661A (en) * 1996-05-06 2000-01-11 Ivee Development Ab System and method for automatic analysis of data bases and for user-controlled dynamic querying
US6317750B1 (en) * 1998-10-26 2001-11-13 Hyperion Solutions Corporation Method and apparatus for accessing multidimensional data
US6320586B1 (en) * 1998-11-04 2001-11-20 Sap Aktiengesellschaft System an method for the visual display of data in an interactive split pie chart
US6411313B1 (en) * 1999-06-14 2002-06-25 Microsoft Corporation User interface for creating a spreadsheet pivottable
US6626959B1 (en) * 1999-06-14 2003-09-30 Microsoft Corporation Automatic formatting of pivot table reports within a spreadsheet
US6750864B1 (en) * 1999-11-15 2004-06-15 Polyvista, Inc. Programs and methods for the display, analysis and manipulation of multi-dimensional data implemented on a computer
US6700575B1 (en) * 2000-03-31 2004-03-02 Ge Mortgage Holdings, Llc Methods and apparatus for providing a quality control management system
US7363584B1 (en) * 2001-04-11 2008-04-22 Oracle International Corporation (Oic) Method and article for interactive data exploration
US6990638B2 (en) * 2001-04-19 2006-01-24 International Business Machines Corporation System and method for using shading layers and highlighting to navigate a tree view display
US7353183B1 (en) * 2001-07-17 2008-04-01 Move, Inc. Method and system for managing and closing a real estate transaction
JP4301395B2 (en) * 2002-02-28 2009-07-22 株式会社沖データ Image forming apparatus
US7170519B2 (en) * 2002-03-29 2007-01-30 Sas Institute Inc. Computer-implemented system and method for generating data graphical displays
US20040205637A1 (en) * 2002-06-25 2004-10-14 Evan Witt Methods and systems for dynamic display of information in an internet application
US7015912B2 (en) * 2003-01-13 2006-03-21 Vendavo, Inc. System and method for the visual display of data in an interactive zebra chart
US20050068320A1 (en) * 2003-09-26 2005-03-31 Denny Jaeger Method for creating and manipulating graphic charts using graphic control devices
US7269801B2 (en) * 2004-03-30 2007-09-11 Autodesk, Inc. System for managing the navigational usability of an interactive map
US20060004718A1 (en) * 2004-07-02 2006-01-05 Mccully Eric Report layout model and method
US7546522B2 (en) * 2004-12-20 2009-06-09 Microsoft Corporation Method, system, and computer-readable medium for applying a global formatting scheme to a chart in an electronic document
US20100185949A1 (en) * 2008-12-09 2010-07-22 Denny Jaeger Method for using gesture objects for computer control

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5894311A (en) * 1995-08-08 1999-04-13 Jerry Jackson Associates Ltd. Computer-based visual data evaluation
CN1695107A (en) * 2002-09-27 2005-11-09 卡西欧计算机株式会社 Graphic display control device for displaying graph and graphic and recording medium
CN1609853A (en) * 2003-06-13 2005-04-27 微软公司 Context association diagram for computer system architecture

Also Published As

Publication number Publication date
US20160314606A1 (en) 2016-10-27
KR20080078811A (en) 2008-08-28
WO2007067580A1 (en) 2007-06-14
CN101322119A (en) 2008-12-10
US20070126736A1 (en) 2007-06-07
US7961188B2 (en) 2011-06-14
US9400973B2 (en) 2016-07-26
US20110246873A1 (en) 2011-10-06
KR101365877B1 (en) 2014-02-21

Similar Documents

Publication Publication Date Title
CN101322119B (en) Persistent formatting for interactive charts
US6147686A (en) Method and system for real-time manipulation of merchandise layout and data collection
US6453302B1 (en) Computer generated presentation system
US7221474B2 (en) Method for visualizing large volumes of multiple-attribute data without aggregation using a pixel bar chart
US20190163687A1 (en) System and method for interacting with virtual maps
US7111235B1 (en) Business description vocabulary for standardized, extensible interoperation
US5806071A (en) Process and system for configuring information for presentation at an interactive electronic device
US7986323B2 (en) Two dimensional user interface for multidimensional data analysis
CA2303725A1 (en) Systems, methods and computer program products for building and displaying dynamic graphical user interfaces
US7340690B2 (en) Space-efficient linear hierarchical view and navigation
US20050234752A1 (en) System and method for a made to specification e-commerce quoting and orders processing system on a stand alone or integrated portal
US20040243471A1 (en) Process and system for authoring electronic information by filling in template pattern with local presentation information
WO2010036481A2 (en) User interface for internet advertisement
US20060168561A1 (en) Method and apparatus for enabling live selection of content for print on demand output
Alexander Excel Dashboards & Reports for Dummies
CN107844298A (en) The method and apparatus for generating entity web page display template
JP2001222613A (en) Method and device for displaying commercial area and medium
US20060064314A1 (en) Multimedia floral merchandising system
JP2978514B2 (en) Product display management method
US20020039114A1 (en) Method and system of navigating using a graphical portal
JPH0218669A (en) Displaying system for selected information on electronic catalog
KR20050064605A (en) Geographical information display apparatus of real-estates and display method thereof
JP3411735B2 (en) Product information management support system and product name display method
Perkins 20 Cartography and Graphicacy
Whitehead et al. Desktop mapping on the Apple Macintosh

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
ASS Succession or assignment of patent right

Owner name: MICROSOFT TECHNOLOGY LICENSING LLC

Free format text: FORMER OWNER: MICROSOFT CORP.

Effective date: 20150421

C41 Transfer of patent application or patent right or utility model
TR01 Transfer of patent right

Effective date of registration: 20150421

Address after: Washington State

Patentee after: Micro soft technique license Co., Ltd

Address before: Washington State

Patentee before: Microsoft Corp.