Session 4:Visualisation:Specifying Range of Data and Selecting Columns:Google charts with Google Docs data

3 Specifying Range of Data and Selecting Columns : Google Charts with Google Docs data

In the previous post, we had described how to create a basic Google Chart from data stored in a Google Doc spreadsheet. In that example, the data was picked up from the default first sheet of the spreadsheet and the data was located in the top left corner. In reality, the data could be stored in any of the other sheets and could be located in any portion of the sheet.

In this example, the Google Docs spreadsheet, has four sheets. For the purpose of drawing our chart we would like to specify that

1. Data to be picked up from sheet named "Demo3"
2. Within this sheet,  from the range C3:I23
3. Within this range from the columns C, D, G, H
4. Given the nature of the data we would like to multiply column G by 1000 before it is plotted