Specifying
Range of Data and Selecting Columns: Google Charts with Google Docs data
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
If you look at the spreadsheet in a browser, the URL will show up as:
https://docs.google.com/spreadsheets/d/1RZ-KVY4h6ZqUY743-R2qtsdJZ1DLDe_YauqX7CDfTYY/edit?usp=sharing
The chart will look as follows:
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
If you look at the spreadsheet in a browser, the URL will show up as:
https://docs.google.com/spreadsheets/d/1RZ-KVY4h6ZqUY743-R2qtsdJZ1DLDe_YauqX7CDfTYY/edit?usp=sharing
The chart will look as follows:
No comments:
Post a Comment