Systems and methods for automated graphing of spreadsheet information

• US 5,461,708 A
• Filed: 04/17/1995
• Issued: 10/24/1995
• Est. Priority Date: 08/06/1993
• Status: Expired due to Term

• Current Assignee: Borland Software Corporation (Open Text Corporation)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Kahn, Philippe R.
• Primary Examiner(s): Nguyen, Phu K.
• Application Number:
  US08/425,665
• Time in Patent Office: 190 Days
• Field of Search: 395/155, 395/156, 395/157, 395/161, 395/140, 345/133, 345/134, 345/135
• US Class Current: 345/440
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

An electronic spreadsheet system of the present invention includes an intelligent graphing module for automatically selecting a graph type based on a user'"'"'s own data. Methods are described for determining the level of complexity present in a user'"'"'s data and for automatically selecting a preferred graph type based on that determined complexity. The system includes a preferred interface for receiving selections from the user indicating an information set (e.g., a block of contiguous or non-contiguous spreadsheet cells) to visualize graphically.

Claims

1. In a computer system, a method for assisting a user with graphing information, the method comprising the steps of:

(a) providing a plurality of different graph types for presenting data sets of varying layout and information content;

(b) receiving as input one of said data sets, said data set including information desired by the user to be plotted as a graph;

(c) examining said data set by said computer system, for determining layout and information content for said data set;

(d) automatically selecting a graph type by said computer system, based on said determined layout and information content for said data set; and

(e) plotting said graph with the information of said data set, said graph having said selected graph type.

2. The method of claim 1, wherein said plurality of graph types includes selected ones of 2-D and 3-D graphs.

3. The method of claim 2, wherein said 2-D graphs include selected ones of two-dimensional Bar, Line, Area, Pie, Doughnut, XY, High-Low, and Radar graphs.

4. The method of claim 2, wherein said 3-D graphs include selected ones of three-dimensional Bar, Line (Ribbon), Area, Pie, Doughnut, and Surface graphs.

5. The method of claim 1, wherein step (b) includes:

selecting from a range of spreadsheet cells storing the data set.

6. The method of claim 5, wherein said selecting from a range of spreadsheet cells includes:

displaying the spreadsheet cells on a screen device; and

selecting desired ones of the spreadsheet cells from the screen device with a pointing device.

7. The method of claim 1, wherein step (c) includes:

dividing by said computer system said received data set into at least one data series having at least one data point;

determining by said computer system how many of said at least one data series exist; and

determining by said computer system how many of said at least one data point exist within said at least one data series, whereby a data set having few data series and few data points is determined by said computer system to be of minor complexity, and whereby a data set having multiple data series and many data points is determined by said computer system to be of major complexity.

8. The method of claim 7, wherein a data set having a single data series is plotted with a 2-D graph type.

9. The method of claim 7, wherein a data set having a single data series is plotted with a 3-D graph type.

10. The method of claim 1, wherein step (d) includes:

ranking said graph types from least complex to most complex, based on suitability of each graph type to illustrate to said user trends present in a particular data set;

ranking said data set from least complex to most complex relative to other data sets, based on layout and information content of said data set; and

selecting a graph type by selecting a graph type complexity ranking which best matches the data set complexity ranking.

11. A system for plotting information stored in information cells as a graph, the system comprising:

a processor and a memory, said memory storing a plurality of different graph types, each of said graph types being suited for plotting a particular set of information;

a screen device for displaying information stored in said information cells;

an input device for selecting desired ones of said information cells;

means, responsive to said input device and responsive to information stored in said selected information cells, for automatically selecting one of said different graph types by said system, based on layout and information content of said selected information cells; and

means for plotting the information stored in said selected information cells as a graph having said selected graph type.

12. The system of claim 11, wherein said plurality of graph types includes selected ones of 2-D and 3-D graphs.

13. The system of claim 12, wherein said 2-D graphs include selected ones of two-dimensional Bar, Line, Area, Pie, Doughnut, XY, High-Low, and Radar graphs.

14. The system of claim 12, wherein said 3-D graphs include selected ones of three-dimensional Bar, Line (Ribbon), Area, Pie, Doughnut, and Surface graphs.

15. The system of claim 11, wherein said input device includes a pointing device operably coupled to a screen cursor.

16. The system of claim 11, wherein said selected information cells comprises a contiguous block of cells.

17. The system of claim 11, wherein said selected information cells comprises a non-contiguous block of cells.

18. The system of claim 11, wherein said means for automatically selecting one of said different graph types includes means for determining layout and information content of said selected information cells comprising:

means for partitioning said selected information cells into at least one data series having at least one data point;

means for determining how many data series are present in said selected information cells; and

means for determining how many data points are present in said at least one data series, whereby a set of information cells having few data series and few data points is determined to be of minor complexity, and whereby a set of information cells having multiple data series and many data points is determined to be of major complexity.

19. The system of claim 11, further comprising:

means for indicating the selected graph type to a user before the information stored in said selected information cells is plotted.

20. In an electronic spreadsheet system including a matrix of information cells, said information cells storing data and formulas operative on said data, a method for assisting a user with plotting graphs, the method comprising the steps of:

(a) providing a plurality of different graph types for presenting information;

(b) selecting desired ones of said information cells to be plotted as a graph;

(c) examining by said system content and layout of the selected information cells; and

(d) selecting by said system, based on the content and layout of the selected information cells, one of said plurality of graph types for plotting the selected information cells.

21. The system of claim 20, further comprising:

(e) plotting the selected information cells as a graph having a type of said selected graph type.

22. The system of claim 21, wherein step (e) includes:

displaying a graph plotting values of the selected information cells on a screen device.

23. The system of claim 21, wherein step (e) includes:

printing a graph plotting values of the selected information cells on a printer device.

24. The system of claim 20, further comprising:

(e) indicating to the user on a screen device said selected graph type;

(f) receiving input from the user indicating acceptance or rejection of said selected graph type; and

(g) plotting the selected information cells as a graph having a type of said selected graph type if the user accepts said selected graph type.

25. The system of claim 20, wherein step (d) includes:

dragging a screen cursor across a selection of said information cells for defining a block of selected information cells.

26. The system of claim 20, wherein said selected information cells includes at least one column and at least one row of cells, and wherein step (c) includes:

examining by said system the layout of said selected information cells by determining how many rows and columns are present;

assigning by said system each row as a data series to be plotted if more columns are present than rows;

assigning by said system each column as a data series to be plotted if more rows are present than columns; and

determining by said system complexity of the selected information cells by counting how many data series are present in the selected information cells.

27. The system of claim 20, wherein step (c) includes:

dividing the selected information cells into at least one data series, each series including a set of cell values, each of which is to be plotted sequentially as a data point on the graph.

28. The system of claim 27, wherein step (c) further includes:

determining by said system content and layout of the selected information cells by counting how many data series are present in the selected information cells and how many cell values are present in said at least one data series.

29. The system of claim 27, wherein step (d) includes:

selecting by said system a 2-D graph type if only a single data series is present in the selected information cells.

30. The system of claim 29, wherein said 2-D graph type includes a selected one of a two-dimensional pie graph, line graph, and bar graph.

31. The system of claim 27, wherein step (d) includes:

selecting by said system a 3-D graph type if a plurality of data series are present in the selected information cells.

32. The system of claim 31, wherein said 3-D graph type includes a selected one of a three-dimensional bar graph, line (ribbon) graph, and surface graph.

33. In an electronic spreadsheet system, an improved method for aiding a user in graphing spreadsheet information, the improvement comprising the steps of:

(a) storing a plurality of different graph types, each of which is suited for a particular content and layout of information;

(b) examining by said system content and layout of information to be graphed; and

(c) selecting by said system a graph type for plotting said information to be graphed by matching content and layout of said information with one of said plurality of graph types which is suited for said content and layout.

34. The method of claim 33, wherein said graph types include 2-D and 3-D graph types.

35. The method of claim 33, wherein step (b) includes:

dividing the information into at least one data series, each series including a set of values, each of which is to be plotted sequentially as a data point on the graph.

36. The method of claim 33, wherein said information to be graphed includes spreadsheet cells, each cell for storing a selected one of data and formulas, said data having a data type, and wherein step (b) includes examining the data type for cells of the information to be graphed.

37. The method of claim 36, wherein said data type includes a selected one of fixed, scientific, currency, percent, date, time, text, and user-defined data types.

38. The method of claim 36, wherein at least one of said cells stores information having a data type of date, and wherein step (c) includes selecting a type of graph suited for presenting a trend of values over time.

39. The method of claim 36, wherein at least one of said cells stores a numeric value.

40. The method of claim 39, wherein step (c) includes:

selecting by said system a type of graph capable of presenting negative values if said information to be graphed includes data having a negative numeric value.