• When [Graph] - [Row Series] is selected, each row is treated as one

 

 

A

B

C

 

 

 

 

 

 

 

 

set of data. Item A data (blue), Item B data (red), and Item C data

 

 

 

 

 

 

 

 

(green) are cumulative, and there are two bars, one for each of the two

 

 

 

 

 

 

 

 

days of the week. This lets you see the cumulative sales for each day.

Sun

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sat

Tip: You can switch an existing graph between column series and row series by tapping [Type] - [Column Series] or [Type] - [Row Series].

Graph Colors and Color Link

Enabling Color Link (so there is a check mark next to it) on the Edit menu will cause the text color of the data being graphed to be used when the data is graphed. Conversely, a color specified on the Graph window will be applied as the text color of the corresponding data.

When Color Link is disabled (so there is no check mark next to it on the [Edit] - [Format] menu), graphing is performed using default colors.

uTo use text colors as graph colors

Example: To draw a stacked line graph using the data in the nearby screenshot, which is the same we graphed under “Column Series and Row Series” (page 229)

1.Configure text color settings for each cell as shown in the nearby screenshot.

•For information about color settings, see “Changing the Text Color and Fill Color of Specific Cells” (page 226).

2.Tap [Graph] - [Column Series].

3.Tap [Edit] - [Format] - [Color Link] so there is a check mark next to [Color Link].

4.Tap [Graph] - [Line] - [Stacked].•This will draw a stacked line graph using the data colors.5.Tap [Type] - [Row Series].

•This switches to a row series graph. For a line graph, the color of each data’s first character (first row character in the case of Column Series, first column character in the case of Row Series) is applied as the line color.

uTo specify the graph drawing color on the Graph window

Example: To continue with the operation in the previous example and change the drawing color on the Graph window

1.On the Graph window, select the point whose color you want to change by tapping it.

•Note that you cannot select a line. Line colors are always the same as the rightmost end point.

2.On the [Edit] menu, tap [Style].

•This displays the Style Settings dialog box.

Chapter 13: Spreadsheet Application

230