Multiple Graphs1

Multiple graphs

Suppose we wish to show several functions on a single graph. Excel is perfectly suited to this task.

sin(x)

cos(x)

sin(x)+cos(x)

0.00

1.00

Highlight all the data and select the chart wizard. Choose x-y scatter plot. Since the left-most column contains the abscissas, the chart wizard will select the other columns for the ordinates. After the chart wizard is finished, you can reenter the formating of the chart to change colors, point sizes, and other artifacts of the chart itself. For example, by selecting one of the graphs, and then right-clicking the mouse, you obtain the formatting menu for the line. Experiment!! There are many, many items to choose from.

0.20

0.98

1.18

0.40

0.39

0.92

1.31

0.60

0.56

0.83

1.39

0.80

0.72

0.70

1.41

1.00

0.84

0.54

1.38

1.20

0.93

0.36

1.29

1.40

0.99

0.17

1.16

1.60

1.00

-0.03

0.97

1.80

0.97

-0.23

0.75

2.00

0.91

-0.42

0.49

2.20

0.81

-0.59

0.22

2.40

0.68

-0.74

-0.06

2.60

0.52

-0.86

-0.34