Abstract: The present invention is developed for providing a method for displaying plural ranges in a spreadsheet in an easy-to understand manner by a simple operation. Based on range specification data entered in each of the plural cells, a zonal range graph displaying each range of the range specification data is displayed in a cell specified by a user. The color and/or pattern of each range may be different from each other in order to enhance the visual understandability. When a cell in which a range graph is displayed is resized, the range graph is also resized according to the new size of the cell. The range graph may be displayed in a longitudinal direction, if needed.

Abstract: An object of the present invention is to conveniently visualize data represented as a ratio or range in a cell of a spreadsheet. A ratio graph image having the length of the ratio to the width of the cell to which the ratio data is input is created and the ratio graph image is located in a predetermined cell. When the size of the ratio graph is changed, the size of the ratio graph is accordingly drawn again to represent the accurate ratio at all times. By registering data in various units in ratio data definition information, the type of data which can be represented in a graphic form is extended.