Direct Column Chart Label Editing via Real-Time Algorithm

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing methods for creating and editing column charts require users to switch between the chart interface and data sheets or spreadsheets, leading to inefficiencies and delayed feedback on label modifications.

Innovation Solution

A display method and computer program product that allows direct editing of column chart labels within the graphical user interface, using a labeling algorithm that updates the chart in real-time without needing to access data sheets or spreadsheets, ensuring immediate feedback and adherence to layout constraints.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If users edit column chart labels by switching to data sheets or spreadsheets, then label modification capability is provided, but user interface complexity increases and feedback time is delayed

Engineering Contradiction:
Improveease of label editingVSAvoidinterface complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent merges the label editing functionality directly into the chart display interface by allowing users to double-click on labels within the chart to enter edit mode. This eliminates the need to switch between separate data sheets and chart views, combining what were previously separate operations into a unified interface.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The patent introduces an intermediary labeling algorithm that automatically recalculates and repositions labels when edited. This mediator processes the user's direct label modifications and ensures proper label placement without requiring users to manually manage the complex relationships between labels and data sources.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Productivity

If users switch between chart interface and data sheets for label editing, then label modification is possible, but time efficiency decreases

Engineering Contradiction:
Improvelabel editing efficiencyVSAvoidtime for switching interfaces
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The patent combines the chart viewing and label editing functions into a single interface operation. Users can edit labels directly on the chart by double-clicking, eliminating the time-consuming process of switching to data sheets, making modifications, and then returning to view the chart.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The patent implements immediate visual feedback by automatically updating the chart display as users type label modifications. The labeling algorithm continuously recalculates label positions during editing, providing real-time feedback without requiring users to exit edit mode or refresh the view.

Inventive Principle:
Principle #23Feedback

3Manufacturing precision

If labeling algorithm executes completely before allowing next edit, then label placement accuracy is maintained, but response speed to user input decreases

Engineering Contradiction:
Improvelabel placement precisionVSAvoidresponse speed to editing
Core Design Contradiction:
Manufacturing precisionVSSpeed

Solution Approach 1:

The patent implements periodic execution of the labeling algorithm during user editing, triggered at regular intervals or after specific input events rather than waiting for complete editing sessions. This allows the system to maintain label placement precision through periodic recalculation while responding more quickly to user inputs.

Inventive Principle:
Principle #19Periodic action

Solution Approach 2:

The patent performs preliminary label placement calculations as users begin editing, providing immediate visual feedback. The labeling algorithm starts executing preliminary adjustments before the user completes their input, ensuring that when the user finishes editing, the labels are already optimally positioned without requiring a lengthy final calculation.

Inventive Principle:
Principle #10Preliminary action

4Stability of the object's composition

If labeling algorithm processes all labels simultaneously, then overall chart consistency is maintained, but processing time for individual edits increases

Engineering Contradiction:
Improvechart label consistencyVSAvoidprocessing time per edit
Core Design Contradiction:
Stability of the object's compositionVSLoss of time

Solution Approach 1:

The patent segments the label processing into individual label units that can be independently edited and recalculated. When a user edits one label, the system processes only that specific label and its immediate impact on chart layout, rather than forcing a complete recalculation of all labels simultaneously. This maintains local consistency while reducing overall processing time.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent implements partial processing of the labeling algorithm by focusing computational resources only on the edited label and its direct neighbors, rather than processing the entire chart. This partial action approach provides sufficient consistency for the modified area while significantly reducing the time required for each editing operation.

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS7716578B2Display method, computer program product and computer system
Publication Date: 2010.05.11 THINK CELL SOFTWARE
  • US7716578B2 patent drawing
  • US7716578B2 patent drawing
  • US7716578B2 patent drawing

AI summary

The present invention relates to a display method. The display method includes displaying a labeled column chart on a graphical user interface, where the column chart having a plurality of labels. The display method further includes entering a first modification of one of the labels via a graphical user interface by a user and starting execution of labeling instructions that implement a labeling algorithm for generating a first modified labeled column chart in response to the entry of the first modification. The first modified labeled column chart is displayed.