BTA3O1                      Unit 2b: Spreadsheets


Activity 10: Combined Graphs with Two Sets of Data

Our last graphing exercise won't require any originality! Sometimes it's useful to have two sets of data on the same graph. For example, bars and lines representing related but not identical data. Have a look at the graph below (numbers ficticious):

The graph suggests our exports (sales of goods to other countries) decline as the value of our dollar increases relative to the United States currency.

How do we create this graph?

1. Enter your data in columns.
2. Select the Chart icon.
3. Click the Custom Types tab.
4. Choose either the Line-Column on 2 axes or Line on 2 axes.
5. Select the series and point to each range for the two data sets.
6. Complete the graph by entering the axes names, titles, etc.
7. Change the colours, size, appearance to make the graph appealling.

Once again we visit thenetride.com. Download the sample spreadsheet and prepare the combined graphs for each of the four scenerios, from easy to not so easy. The key is to clearly identify the series in each case, especially when the columns containing the data aren't adjacent.

Finally, visit this web page to see what is possible. Any takers?