Visual relationship between table values
Provided are devices and methods for generating and displaying a table chart in which numerical values are replaced by objects. In one example, a method includes receiving a data table including a 2D array of cells storing numerical values, generating a table chart including a 2D array of cells visually depicting a relationship between the numerical values in the data table wherein the table chart represents the numerical values as objects in the table chart, and a size of an object varies based on a numerical value from the data table that is represented by the respective object in comparison to remaining numerical values from the data table that are represented by remaining objects, and displaying the table chart via a user interface. The generated table chart provides a quicker understanding of a relationship between values in a data table.
1. A device for generating and displaying a visual relationship between table values, the device comprising:
a storage configured to store a data table comprising a two-dimensional (2D) array of cells storing numerical values therein;
a processor configured to generate a table chart comprising a 2D array of cells visually depicting a relationship between the numerical values in the data table, wherein the table chart represents the numerical values of the data table as objects in the table chart, and, for each object, a size of the object is generated based on a numerical value from the data table that is represented by the respective object in comparison to remaining numerical values from the data table that are represented by remaining objects in the table chart; and
an output configured to output the table chart to a user interface,
wherein the processor is further configured to receive a selection of an object included in the table chart, via the user interface, and the output is further configured to output a numerical value that is represented by the selected object via the user interface.
2. The device of claim 1 , wherein the numerical values stored in the data table include a first numerical value and a second numerical value that is smaller in value than the first numerical value, and
the processor generates a first object in the table chart that represents the first numerical value and a second object in the table chart that represents the second numerical value, and a generated size of the second object is smaller than a generated size of the first object to identify that the second object represents a smaller numerical value than the first object.
3. The device of claim 1 , wherein a shape of the objects in the table chart are common throughout the table chart.
4. The device of claim 1 , wherein a shape of each object in the table chart is a circle, and a radius of the circle varies based on a numerical value represented by the respective object in comparison to remaining numerical values represented by remaining objects in the table chart.
5. The device of claim 1 , wherein the processor is further configured to generate a bar graph for each column from among a plurality of columns of the table chart, each bar graph representing a summation of numerical values represented by a plurality of objects included in the respective column of the table chart, and
the output is configured to output a bar graph chart including each bar graph such that each bar graph is positioned adjacent to its respective column in the table chart.
6. The device of claim 1 , wherein the processor is further configured to generate a bar graph for each row from among a plurality of rows of the table chart, each bar graph representing a summation of numerical values represented by a plurality of objects included in the respective row of the table chart, and
the output is configured to output a bar graph chart including each bar graph such that each bar graph is positioned adjacent to its respective row in the table chart.
7. The device of claim 1 , wherein the processor is configured to color at least one object included in the table chart a different color than the remaining objects to indicate additional information about a numerical value represented by the at least one object.
8. The device of claim 1 , wherein the processor is configured to generate shading around an outer edge of at least one object to indicate additional information about a numerical value represented by the at least one object.
9. The device of claim 1 , wherein the processor is configured to generate a broken line around an outer edge of at least one object to indicate additional information about a numerical value represented by the at least one object.
10. A method for generating and displaying a visual relationship between table values, the method comprising:
receiving a data table comprising a two-dimensional (2D) array of cells storing numerical values therein;
generating a table chart comprising a 2D array of cells visually depicting a relationship between the numerical values in the data table, wherein the table chart represents the numerical values of the data table as objects in the table chart, and, for each object, a size of the object is generated based on a numerical value from the data table that is represented by the respective object in comparison to remaining numerical values from the data table that are represented by remaining objects in the table chart;
displaying the table chart via a user interface; and
receiving a selection of an object included in the table chart, via the user interface, and in response, outputting a numerical value that is represented by the selected object via the user interface.
11. The method of claim 10 , wherein the numerical values stored in the data table include a first numerical value and a second numerical value that is smaller in value than the first numerical value, and
the generating comprises generating a first object in the table chart that represents the first numerical value and a second object in the table chart that represents the second numerical value, and a generated size of the second object is smaller than a generated size of the first object to identify that the second object represents a smaller numerical value than the first object.
12. The method of claim 10 , wherein a shape of the objects in the table chart are common throughout the table chart.
13. The method of claim 10 , wherein a shape of each object in the table chart is a circle, and a radius of the circle varies based on a numerical value represented by the respective object in comparison to the remaining numerical values represented by the remaining objects in the table chart.
14. The method of claim 10 , wherein the generating further comprises generating a bar graph for each column from among a plurality of columns of the table chart, each bar graph representing a summation of numerical values represented by a plurality of objects included in the respective column of the table chart, and
displaying a bar graph chart including each bar graph such that each bar graph is positioned adjacent to its respective column in the table chart.
15. The method of claim 10 , wherein the generating further comprises generating a bar graph for each row from among a plurality of rows of the table chart, each bar graph representing a summation of numerical values represented by a plurality of objects included in the respective row of the table chart, and
displaying a bar graph chart including each bar graph such that each bar graph is positioned adjacent to its respective row in the table chart.
16. The method of claim 10 , wherein the generating comprises coloring at least one object included in the table chart a different color than the remaining objects to indicate additional information about a numerical value represented by the at least one object.
17. The method of claim 10 , wherein the generating comprises generating shading around an outer edge of at least one object to indicate additional information about a numerical value represented by the at least one object.
18. The method of claim 10 , wherein the generating comprises generating a broken line around an outer edge of the at least one object to indicate additional information about a numerical value represented by the at least one object.
19. A non-transitory computer readable medium having stored therein instructions that when executed cause a computer to perform a method for generating and displaying a visual relationship between table values, the method comprising:
receiving a data table comprising a two-dimensional (2D) array of cells storing numerical values therein;
generating a table chart comprising a 2D array of cells visually depicting a relationship between the numerical values in the data table, wherein the table chart represents the numerical values of the data table as objects in the table chart, and, for each object, a size of the object is generated based on a numerical value from the data table that is represented by the respective object in comparison to remaining numerical values from the data table that are represented by remaining objects in the table chart;
displaying the table chart via a user interface; and
receiving a selection of an object included in the table chart, via the user interface, and in response, outputting a numerical value that is represented by the selected object via the user interface.