THREE-WAY RELATIONSHIP GRAPHS

[Link Map]
begin comments text sound
line

By using both the pivot table wizard and the chart wizard it is possible to obtain a graphical representation of two continuous variables categorised by a third qualitative variable.

First create a pivot table, using hour as the row field, day as the column field and rad as the data field. (Since there is only one value of rad in each combination of fields, the function sum simply returns this value.)
Now highlight the newly generated table (shown right), excluding the grand total row and column) and activate the chart wizard.
Both the following graphs show rad against hour split by day. The first was created using the line type and the second using the xy scatter plot.

         

The format of the two graphs can be changed in any way you like. For example, the symbols on the second graph can be customised by double clicking on each data series in turn and selecting various options from the dialog box which appears. You can also design your own symbols, copying and pasting them onto the selected data series.
The orientation of the 3-D line graph can also be changed by clicking on the graph and dragging any of the six nodes. This way the graph can be viewed from all perspectives.

line
Basic statistics in Excel   23.1.99   Page: 13 of 25