Thanks for working on this.. But, i dont see any attachment with your reply.. Please attach the modified file...Thanks On Tuesday, August 6, 2013 3:56:45 PM UTC-5, asgallant wrote:
> You don't want to put the HTML inside a KML file, it should be run > directly as an HTML file from your browser. For that matter, the DataArray > and StatArray files aren't really KML files, but the Visualization API > doesn't care about that. > > I reworked the HTML example to handle the dynamic columns (see attached). > It makes the assumption that column 0 is always the x-axis column and that > the StatArray file is structured like this: > > ['Inventory', 'Safety stock', 'weight', 'hdsjka'] > > I can't test this locally, as my system rejects AJAX requests made from > the "file" protocol, so you will have to debug it yourself. Use the > developer's console in Chrome or Firefox to see what errors pop up. > > On Tuesday, August 6, 2013 2:04:04 PM UTC-4, kpj wrote: >> >> thanks for your support >> >> I pasted your code in a kml file..But, No charts are showing up. >> Again, My columns are dynamic .. Thats the whole reason to read the >> column labels and keep it in a different file.. >> Please find my Kml file in the attachment. >> Also, Please let me know a way to read the column lables from the file >> rather than entering the column labels in the code. >> I would really appreciate if you could help me with the control wrapper >> for the columns >> >> Thanks a ton for your help >> >> >> >> On Tuesday, August 6, 2013 12:23:09 PM UTC-5, asgallant wrote: >> >>> The best way to handle this depends on how frequently the data changes >>> in your Excel spreadsheet. If you are updating that data frequently, then >>> it makes sense to set up a query like this. Any data that doesn't change >>> (like, perhaps, the columns in the column filter) is easier to hard-code in >>> the javascript. I attached a sample HTML file that assumes your data can >>> change but the columns do not. >>> >>> On Tuesday, August 6, 2013 11:58:50 AM UTC-4, kpj wrote: >>>> >>>> Thanks for your response. >>>> Please find the data file and also columnfilter file in the attachments. >>>> I have written an Excel to KML converter in VBA which has modules that >>>> convert the excel data into array format and also has a module that pulls >>>> all the column lables and puts it in a column array(for creating column >>>> filter controlwrapper) >>>> so, My excel to kml converter outputs a Main kml file which has a cdata >>>> section..inside <Balloon style>.. I am including my google charts in that >>>> cdata section.. >>>> please find my kml output file in the attachment.. >>>> i would like to develop country,, city and column filter control >>>> wrappers so, that the user can select his options and view the statistics >>>> data in charts.. >>>> My converter writes the Main kml file and these two data files at the >>>> same file path... >>>> i have to pull the data by giving that URL >>>> Please correct me if i am wrong.. >>>> Thanks alot for your quick response >>>> >>>> >>>> On Tuesday, August 6, 2013 10:41:45 AM UTC-5, asgallant wrote: >>>> >>>>> First off, this needs to be in an HTML file with appropriate HTML >>>>> structure or it won't do anything. Second, in order to help you with >>>>> pulling the data from your local files, it would help to see what the >>>>> contents of those files look like. Third, you have 3 controls, 1 chart, >>>>> and two data sources - I need to know how these should relate to one >>>>> another in order to help you make this work. >>>>> >>>>> On Tuesday, August 6, 2013 11:25:32 AM UTC-4, kpj wrote: >>>>>> >>>>>> Hi, >>>>>> I am a new bie who is trying to chart the excel data. >>>>>> >>>>>> I have written the code..but, I am sure there are lot of mistakes in >>>>>> it..Could you please help me code? >>>>>> My requirements are: >>>>>> 1) Reading data from the files which are in a url >>>>>> First file is excel sheet data >>>>>> second file consists of column labels for creating a column filter >>>>>> control wrapper. >>>>>> >>>>>> 2) creating dashboard and drawing pie and bar chart based on the >>>>>> column filter >>>>>> >>>>>> I need help in reading the formatted data and creating the above >>>>>> control wrappers and also creating pie and bar charts.. >>>>>> I have written( some of it copy pasted) a code...which is not showing >>>>>> anything( obviously, it has lot of errors) >>>>>> Could you please take a look at the code and correct it? >>>>>> I would really appreciate your help, as this is an important task to >>>>>> complete .... >>>>>> please find the code in the attachment. >>>>>> Thanks in advance >>>>>> >>>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
