Unfortunately, if you want to use the gadget on top of Google Spreadsheets page, you can only use ranges, and there is no way to ignore col B. A few things you can do: 1. You can create another sheet in the same spreadsheet, with formulas that only take the relevant cols from the other sheet, and use the chart on this data. 2. If you want to display the chart on other places, and not on the spreadsheet (but still read the data from the spreadsheet), you can publish it to your iGoogle page (or anyother), and there you can append to the data source url, a parameter called tq in which you can specify data manipulations. See http://code.google.com/apis/visualization/documentation/querylanguage.html#Setting_the_Query_in_the_Data_Source_URLfor more details. In your case it will be like adding to the url: *&tq=select A,C*
VizGuy On Thu, Nov 20, 2008 at 10:27 PM, Pragan <[EMAIL PROTECTED]> wrote: > > Hi, > > How to just display A1 and C1? If I try doing it with a comma or &, it > doesnt work. > I am trying to do this to show something like this > A B C > 1 pragan learn api > 2 Pragan check google > 3 > So I want to just output > pragan api > Pragan google > by leaving the value in col B. I guess we cannot define range in this > case. Please let me know. > > thanks > On Nov 20, 8:11 am, VizGuy <[EMAIL PROTECTED]> wrote: > > In the data source url, when it points to a Google Stpreadsheets page, > you > > can specify the sheet and the range as a apart of the URL:The range > > parameter in the format of A1:B5 can limit the selected range, and the > sheet > > can be set by a parameter sheet=<sheetName> > > > > So the entire url will be something like: > http://spreadsheets.google.com/tq/key=12345&sheet=Sheet1&range=A1:B2 > > > > VizGuy > > > > On Wed, Nov 19, 2008 at 5:45 PM, Mathieu <[EMAIL PROTECTED]> > wrote: > > > > > Hello, > > > > > I have a spreadsheet on "Google Documents" with a sheet1, a > > > sheet2, ... > > > > > 2 things : > > > > > - I want to select a sheet of my spreadsheet using JavaScript > > > functions, is it possible ? > > > - After that, i want to select a column of this sheet, and draw only > > > this one on my iGoogle page, is it possible ? > > > > > I did that : > > > > > > --------------------------------------------------------------------------------------------------- > > > function initialize() { > > > // The URL here is the URL of the spreadsheet. > > > // This is where the data is. > > > var query = new google.visualization.Query([EMAIL PROTECTED]); > > > query.send(draw); > > > } > > > > > function draw(response) { > > > if (response.isError()) { > > > alert("Error in query") > > > } > > > var ticketsData = response.getDataTable(); > > > var table = new google.visualization.Table > > > (document.getElementById('table_div')), > > > > > // HERE I WANT TO SELECT A SHEET i.e "sheet1".. > > > // AFTER I WANT TO SELECT AND DRAW A COLUMN OF THIS SHEET, i.e > > > "adress" > > > > > table.draw(ticketsData, {allowHtml: true, showRowNumber: > > > true}); > > > > > } > > > > > > --------------------------------------------------------------------------------------------------- > > > > > Thanks by advance, > > > > > Mat > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
