[visualization-api] Line Chart from MSSQL without formatting to json

2014-09-04 Thread Spark Plasma
I noticed the example which mentions it can be linked to a database https://developers.google.com/chart/interactive/docs/php_example requires the data to be formatted in .json format. I would like to keep my data in the format which is shown in the Line Charts

[visualization-api] Google Timeline fix different color for each timesheets

2014-09-04 Thread Ákos Kovács
I have a timeline with a lot of rows and in each rows are several timesheets. I would like to fix for each timesheet an exact color, so one type of timesheet will have same color in every row. I am using this code: var options = { colors: ['#0C14F2', '#114C9E', '#ee8800', '#F6FF00'],

[visualization-api] Export Google Chart in Excel using Javascript ASP.NetC#

2014-09-04 Thread Gaurav Mishra
Hi All, I am using Google Chart in a web Application. I want to export Google Chart in Excel. Google Chart Provides Image Data as *data:image/png* followed by coded string (“*data:image/png;base64,iVBO…*” ). It is easily rendered in HTML and PDF(using JsPDF ) but not working in excel

[visualization-api] Re: Multiple rows in one tooltip

2014-09-04 Thread Alexandre Carrie
Hello Andrew and thanks for the answer. But what I want is this : https://lh3.googleusercontent.com/-hfPfEvM3yAc/VAhda_SjGxI/AB4/kA-pT-jZ8cM/s1600/HELP.png For the multiples bloc on the right. I would like to have just one bloc but with the same list in the tooltip. Is it possible? Le

[visualization-api] Adding additional information to tooltip on line chart

2014-09-04 Thread Brian Cleere
Hi guys, I'm new to the visualization API and I've searched for information on this prior to posting. I'm plotting the graph below, but am looking to add additional information to the tooltip that is shown when a user hovers over a point. So for example, instead of the tooltip just showing:

Re: [visualization-api] Line Chart from MSSQL without formatting to json

2014-09-04 Thread 'Sergey Grabkovsky' via Google Visualization API
As our documentation states, Google Charts requires your data to be formatted as JSON. There isn't really any way to get around it, but you could format as a CSV if you prefer that instead. On Thu Sep 04 2014 at 2:39:04 AM Spark Plasma bajagui...@gmail.com wrote: I noticed the example which

Re: [visualization-api] Adding additional information to tooltip on line chart

2014-09-04 Thread 'Sergey Grabkovsky' via Google Visualization API
Hi Brian, unfortunately there's no automated way to do this. You only option is to use HTML tooltips and create the entire tooltip as an HTML string. On Thu Sep 04 2014 at 9:37:55 AM Brian Cleere cleerebr...@gmail.com wrote: Hi guys, I'm new to the visualization API and I've searched for

[visualization-api] Re: Google Annotated Timeline not displayed in servlet/ when loaded form external file

2014-09-04 Thread simran kaur
http://lexiconhub.tk/index/quickfix/annotated-timeline-with-servlets/#.VAh7ZXnraP8 Have a look. Here is the complete code that works with servlets On Thursday, 12 August 2010 20:19:47 UTC+5:30, Peter Watters wrote: Hi all, I have been having a bizarre issue with the Google Annotated

[visualization-api] How to populate a variable with the value of a cell

2014-09-04 Thread Lance Greenwood
Hi all, I'm not a developer - just trying to do a few free things for our school to help out so any assistance is greatly appreciated. I'm trying to figure out how to get a value from a Google Spreadsheet (cell reference F2) to populate a variable in some HTML that I can then use to display

[visualization-api] Re: Embedding a chart on a web paeg from a Google Sheet

2014-09-04 Thread Andrew Gallant
First, your query URL needs to be adjusted slightly: https://docs.google.com/spreadsheets/d/16HsbYp-W-keFce7CvPBVPPdxSFR_eSoQ5-P4Y791xjk/ gviz/tq. That will return the data in the appropriate format. To get the data from cell f2, you have to make a second query to this URL:

[visualization-api] Re: newbie: issues with org chart

2014-09-04 Thread Andrew Gallant
Your first row should have a null value in the second element: $tmp1 = array(Mike, null, ); $tmp2 = array(Jim, Mike, test1); $tmp3 = array(Bob, Jim, Bob Sponge); $tmp4 = array(Carol, Bob, ); as no element can be its own parent (Mike cannot be have Mike as a parent) and there must be a root

[visualization-api] Re: Color for Timeline Chart with 3 categories

2014-09-04 Thread Andrew Gallant
In case you are still looking for a solution, I found a way to do this that actually works properly using the style column role to color the bars without having to go through the process of building the array of colors: http://jsfiddle.net/asgallant/axr7h/8/ On Tuesday, May 20, 2014 8:12:48 PM

[visualization-api] Re: Google Timeline fix different color for each timesheets

2014-09-04 Thread Andrew Gallant
Using the colors option is not the best approach, as the process for setting this option correctly to get the colors you want is rather complex. A much simpler way to do this is to use a style role column that has the desired color for the bar listed directly in it, eg: var data =

[visualization-api] Re: Export Google Chart in Excel using Javascript ASP.NetC#

2014-09-04 Thread Andrew Gallant
You have to save the image/octet stream as a .png file and then import the file into Excel. To save the stream as a file, set the src of an img tag to the URI, then right-click on the generated image and click save as. On Thursday, September 4, 2014 5:09:31 AM UTC-4, Gaurav Mishra wrote: Hi

[visualization-api] Re: Multiple rows in one tooltip

2014-09-04 Thread Andrew Gallant
What do you mean by the multiples bloc on the right? On Thursday, September 4, 2014 8:40:47 AM UTC-4, Alexandre Carrie wrote: Hello Andrew and thanks for the answer. But what I want is this : https://lh3.googleusercontent.com/-hfPfEvM3yAc/VAhda_SjGxI/AB4/kA-pT-jZ8cM/s1600/HELP.png

[visualization-api] Google charts api used in windows phone app

2014-09-04 Thread Carla Cartin
Hello, We have developed a responsive website using google charts api for displaying some graphs. Then we used Phonegap in order to create apps for android, windows and apple. We put our app in android store and all works fine. But our windows app once in the Windows store does not display the

[visualization-api] Re: Embedding a chart on a web paeg from a Google Sheet

2014-09-04 Thread Lance Greenwood
Andrew you are a star! I've seen you post solutions for lots of people on here - thanks so much for your time. On Friday, 5 September 2014 11:32:17 UTC+10, Andrew Gallant wrote: First, your query URL needs to be adjusted slightly:

[visualization-api] Re: How to populate a variable with the value of a cell

2014-09-04 Thread Lance Greenwood
Solved for me in the other post: https://groups.google.com/forum/#!topic/google-visualization-api/Zwp4icWxb9c Thanks again Andrew Gallant - you are a legend! -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To unsubscribe from