[visualization-api] Re: Vertical Marker on Line Chart

[Stefan Poninghaus]

Hi Richard,

That was a perfect solution for what I was looking for. Its also worth 
noting that you can use this to do horizontal lines as well, or a 
crosshair, through adding a trend line instead of a error bar.

Thanks


On Friday, 26 June 2015 04:04:12 UTC+12, Richard Hammitt wrote:
>
> You may consider the use of error bars.  I carried this trick over from 
> Excel.  
>
> 1) Add another column to your chart in Advanced Edit, Recommendations, 
> Data Range.  
> 2) Add a number to a cell in that column within your Y-axis range 
> corresponding to the location of your vertical line. 
> 3) In Advanced Edit, Customization, Series, pick your newly created 
> column.   You can add an error bar for the cell you chose in 2) by going to 
> the Error Bars and selecting Constant from the Error Bar drop down menu.
> 4) Extend the error bar as high and low as you want.  You can fix the 
> Y-Axis range if your error range raises or lowers the chart Y range.
>
> I hope this helps!
>
> On Wednesday, May 16, 2012 at 9:50:42 AM UTC-5, Jim wrote:
>>
>> Is it possible to add a vertical marker for a line / area chart?  For 
>> example, say my x-axis range is 0-50 and I want to show a vertical 
>> line at 33.  Is that possible?  I couldn't find this in the 
>> documentation.
>
>
> This message and any files transmitted with it are the property of 
> Sigma-Aldrich Corporation, are confidential, and are intended solely for 
> the use of the person or entity to whom this e-mail is addressed. If you 
> are not one of the named recipient(s) or otherwise have reason to believe 
> that you have received this message in error, please contact the sender and 
> delete this message immediately from your computer. Any other use, 
> retention, dissemination, forwarding, printing, or copying of this e-mail 
> is strictly prohibited.
>

-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/654f2309-1a27-4968-a50e-abcdbfb04e94%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Customizing tooltip in charts

['Daniel LaLiberte' via Google Visualization API]

Hi Brandon,

You can provide your own custom tooltip text, using the 'tooltip' role, but
you then have to generate the entire thing.   We need to provide an easier
way to customize tooltips.

On Fri, Oct 7, 2016 at 4:28 PM, Brandon  wrote:

> Tooltips currently show the following:
>
> X
> "Y-label": Y
>
> I want it to show:
>
> "X-label": X
> "Y-label": Y
>
> Is there a way to force the x variable's name to show?
>
>
>
> --
> 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 google-visualization-api+unsubscr...@googlegroups.com.
> To post to this group, send email to google-visualization-api@
> googlegroups.com.
> Visit this group at https://groups.google.com/
> group/google-visualization-api.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/google-visualization-api/138099f0-dbf9-4a2c-89e3-
> 9132996997ab%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com    5CC, Cambridge MA

-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJNvR7QXgwHk0YBi95GKgu-uXCe5S3iKeDwsW0LjyeZU_A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] How to plot multiple series with different time values one the same line chart?

[Julien Ricard]

Hi,

I have a set of items with the following values: [username (string), score 
(number), date (datetime), comment (string)].

e.g.
['joe', 0.3, 5/5/16, "bla"]
['joe', 0.6, 6/5/16, "bli"]
['jim', 0.4, 6/5/16, "blo"]
['jim', 0.7, 7/5/16, "blu"]

I want to plot one line for each username (I'll have more than 2) on the 
same line chart, with the date as the horizontal axis and the score on the 
vertical axis, with a different color for each line.

Something like the "multiple line types" example on the doc here 
, 
but with more than more than two lines and different time values.

I could not find how to it with Google Graph. Anybody can help / point me 
to some doc?

Thanks you
Julien


-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/84c0faeb-c21d-4cfb-985b-39055ddcfbbb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] issue with google piechart on some sites

['Daniel LaLiberte' via Google Visualization API]

Hi Derek,

It would help to see pointers to the actual web pages, so we could see what
the PHP code generates.   We can't really help otherwise.  If you 'view
source' on those pages, you might notice what has gone wrong.

On Sun, Oct 9, 2016 at 2:23 PM, Derek McGuire 
wrote:

> I have s script I developed for a CMS and I have been implementing the
> Google Piechart into the system. I just put the updates on my site and a
> few test sites from the CMS community, and on 2 of the 5 sites, and error
> occurs with the piechart.
> I am trying to figure out why on these 2 sites, its not working. The error
> is instead of displaying the piechart as expected, it displays "*a is not
> a function*".
> Below are 2 images, The first screenshot is it working on one of the test
> sites and the other is where it's not. The code that is being used is as
> follows.
>
>   echo 'https://www.gstatic.com/
> charts/loader.js">' , PHP_EOL
>   ,'
>   google.charts.load("current", {packages:["corechart"]});
>   google.charts.setOnLoadCallback(drawChart);
>   function drawChart() {
> var data = google.visualization.arrayToDataTable([
>   [\'Task\', \'Bots Caught\'],
>   [\'Wait Script\', '.$waitscript.'],
>   [\'Text Removal\', '.$textremoval.'],
>   [\'Honeypot / Hidden Question\', '.$hidden.'],
>   [\'Custom Question\', '.$customquestion.'],
>   [\'SFS Blacklist\', '.$sfsspam.'],
>   [\'BotScout Blacklist\', '.$bscheck.'],
>   [\'FSpamlist Blacklist\', '.$fscheck.']
> ]);
>
> var options = {
>   title: \'Honeypot Blocker Results PieChart\',
>   is3D: true,
>  backgroundColor: \''.$rowcolor2.'\',
>  titleTextStyle: {color: \''.$fontcolor.'\', fontSize: \'32px\'},
>legendTextStyle: {color: \''.$fontcolor.'\', fontSize: \'16px\'},
>  colors: [\'#00A209\', \'#486EFF\', \'#AB00BC\', \'#C30012\', \'#D08E00\',
> \'#00C3B4\', \'#77D100\'],
> };
>
> var chart = new google.visualization.PieChart(
> document.getElementById(\'piechart_3d\'));
> chart.draw(data, options);
>   }
> ' , PHP_EOL;
>
>
> Working
>
>
> 
>
>
> Not working
>
>
> 
>
>
> Anyone have any ideas why this does work on 3 out of the 5 sites and on 2
> of them, it would display the error  "*a is not a function*"? Any help
> would be appreciated.
>
> --
> 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 google-visualization-api+unsubscr...@googlegroups.com.
> To post to this group, send email to google-visualization-api@
> googlegroups.com.
> Visit this group at https://groups.google.com/
> group/google-visualization-api.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/google-visualization-api/e6a5a55b-5532-4a22-b268-
> 267712029f5c%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com    5CC, Cambridge MA

-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJMGjTD8V1nL_C0%3DuQc%3DVDzpScmP8nyoUH%2BXZogWKRt%2BSg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Google Charts addRows not accepting Dates when passed via parsed String

['Daniel LaLiberte' via Google Visualization API]

Hi Vincent,

We have tried to unify the various ways of setting up DataTables, but there
have been changes in how dates are handled recently, and it appears likely
the case you found has been either broken, or always was broken.

Can you can use new Data(...) without quotes?  JSON notation doesn't allow
new Date() constructors, so that is why the "Date(...)" format is supported
at least there.  When you use JSON.parse() you are just turning the string
into an anonymous JS object, so if you can use the anonymous JS object
instead, with new Date() constructors, that would be the simplest
workaround.

On Mon, Oct 10, 2016 at 6:10 AM, Vincent Holland-Keen <
vincent.hk...@gmail.com> wrote:

> Hi,
>
> I've been struggling for days to get dates working with a chart and have
> finally come to the (possibly erroneous) conclusion that there's a
> difference between the implementation of dates in the DataTable function
> and in the addRows function.
>
> This JSFiddle hopefully shows what I mean: https://jsfiddle.net/
> fiskerton/vc4o0710/1/
>
> If a DataTable is created with both columns and rows, passing in a
> JSON.parse'd string with a date value in the format 'Date(,MM,DD)'
> works fine. If that same format is passed to addRows, the console throws
> the error: 'Uncaught Error: Type mismatch. Value Date(,MM,DD) does not
> match type date in column index 1. I haven't found any other format that
> successfully takes a string containing a date and gets it to work with
> addRows - e.g. 'new Date(,MM,DD' fails with same error.
>
> Is there something I've missed?
>
> Thanks.
>
> --
> 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 google-visualization-api+unsubscr...@googlegroups.com.
> To post to this group, send email to google-visualization-api@
> googlegroups.com.
> Visit this group at https://groups.google.com/
> group/google-visualization-api.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/google-visualization-api/6294cb99-9812-471b-87fc-
> 7b040a6972c2%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com    5CC, Cambridge MA

-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJPwbaFF2cjPdqWefrdn7FFfbYFHSTp%3DQZMHa%2Bx7hGNr3g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Multiple google charts issue in IE9 - error 'Microsoft JScript runtime error: 'gvjs_lK' is undefined'

['Daniel LaLiberte' via Google Visualization API]

Thanks for your report Steve.

Unfortunately, I no longer have access to IE9 for testing.  I know it would
be difficult, but if you can get any more clues about what is happening
when the error occurs, we might be able to fix it without testing locally.
I would suspect the problem involves the use of some feature that IE9 does
not support.

On Thu, Oct 13, 2016 at 8:40 AM, Steve Dyson  wrote:

> Google multiple charts on the same page don't work in IE9. Works fine in
> FireFox.
>
> I get error 'Microsoft JScript runtime error: 'gvjs_lK' is undefined'
>
> Here is the example and code snippet. It is the same example given on
> google chart website.
>
> https://developers.google.com/chart/interactive/docs/basic_multiple_charts
>
> 
>
> 
>
>   // Load Charts and the corechart package.
>   google.charts.load('current', {'packages':['corechart']});
>
>   // Draw the pie chart for Sarah's pizza when Charts is loaded.
>   google.charts.setOnLoadCallback(drawSarahChart);
>
>   // Draw the pie chart for the Anthony's pizza when Charts is
> loaded.
>   google.charts.setOnLoadCallback(drawAnthonyChart);
>
>   // Callback that draws the pie chart for Sarah's pizza.
>   function drawSarahChart() {
>
> // Create the data table for Sarah's pizza.
> var data = new google.visualization.DataTable();
> data.addColumn('string', 'Topping');
> data.addColumn('number', 'Slices');
> data.addRows([
>   ['Mushrooms', 1],
>   ['Onions', 1],
>   ['Olives', 2],
>   ['Zucchini', 2],
>   ['Pepperoni', 1]
> ]);
>
> // Set options for Sarah's pie chart.
> var options = {title:'How Much Pizza Sarah Ate Last Night',
>width:400,
>height:300};
>
> // Instantiate and draw the chart for Sarah's pizza.
> var chart = new google.visualization.PieChart(
> document.getElementById('Sarah_chart_div'));
> chart.draw(data, options);
>   }
>
>   // Callback that draws the pie chart for Anthony's pizza.
>   function drawAnthonyChart() {
>
> // Create the data table for Anthony's pizza.
> var data = new google.visualization.DataTable();
> data.addColumn('string', 'Topping');
> data.addColumn('number', 'Slices');
> data.addRows([
>   ['Mushrooms', 2],
>   ['Onions', 2],
>   ['Olives', 2],
>   ['Zucchini', 0],
>   ['Pepperoni', 3]
> ]);
>
> // Set options for Anthony's pie chart.
> var options = {title:'How Much Pizza Anthony Ate Last Night',
>width:400,
>height:300};
>
> // Instantiate and draw the chart for Anthony's pizza.
> var chart = new google.visualization.PieChart(
> document.getElementById('Anthony_chart_div'));
> chart.draw(data, options);
>   }
>
> 
>
> https://www.gstatic.com/
> charts/loader.js">
>
> 
>   
> 
> 
>   
> 
>
>
> 
>
>
> --
> 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 google-visualization-api+unsubscr...@googlegroups.com.
> To post to this group, send email to google-visualization-api@
> googlegroups.com.
> Visit this group at https://groups.google.com/
> group/google-visualization-api.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/google-visualization-api/bcf3ac38-ed14-404c-9f53-
> 3307311efc96%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com    5CC, Cambridge MA

-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJN3d27ZnoeG63Fw%3DS6EitBC7NLdo83E36743qaWNAZoPg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Multiple google charts issue in IE9 - error 'Microsoft JScript runtime error: 'gvjs_lK' is undefined'

[Steve Dyson]

Google multiple charts on the same page don't work in IE9. Works fine in 
FireFox.

I get error 'Microsoft JScript runtime error: 'gvjs_lK' is undefined'

Here is the example and code snippet. It is the same example given on 
google chart website. 

https://developers.google.com/chart/interactive/docs/basic_multiple_charts





  // Load Charts and the corechart package.
  google.charts.load('current', {'packages':['corechart']});

  // Draw the pie chart for Sarah's pizza when Charts is loaded.
  google.charts.setOnLoadCallback(drawSarahChart);

  // Draw the pie chart for the Anthony's pizza when Charts is 
loaded.
  google.charts.setOnLoadCallback(drawAnthonyChart);

  // Callback that draws the pie chart for Sarah's pizza.
  function drawSarahChart() {

// Create the data table for Sarah's pizza.
var data = new google.visualization.DataTable();
data.addColumn('string', 'Topping');
data.addColumn('number', 'Slices');
data.addRows([
  ['Mushrooms', 1],
  ['Onions', 1],
  ['Olives', 2],
  ['Zucchini', 2],
  ['Pepperoni', 1]
]);

// Set options for Sarah's pie chart.
var options = {title:'How Much Pizza Sarah Ate Last Night',
   width:400,
   height:300};

// Instantiate and draw the chart for Sarah's pizza.
var chart = new 
google.visualization.PieChart(document.getElementById('Sarah_chart_div'));
chart.draw(data, options);
  }

  // Callback that draws the pie chart for Anthony's pizza.
  function drawAnthonyChart() {

// Create the data table for Anthony's pizza.
var data = new google.visualization.DataTable();
data.addColumn('string', 'Topping');
data.addColumn('number', 'Slices');
data.addRows([
  ['Mushrooms', 2],
  ['Onions', 2],
  ['Olives', 2],
  ['Zucchini', 0],
  ['Pepperoni', 3]
]);

// Set options for Anthony's pie chart.
var options = {title:'How Much Pizza Anthony Ate Last Night',
   width:400,
   height:300};

// Instantiate and draw the chart for Anthony's pizza.
var chart = new 
google.visualization.PieChart(document.getElementById('Anthony_chart_div'));
chart.draw(data, options);
  }



https://www.gstatic.com/charts/loader.js";>
   

  


  

   




-- 
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/bcf3ac38-ed14-404c-9f53-3307311efc96%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] different between new google.charts.Bar & google.visualization.ComboChart

[natarajan govindavel]

Hi sergey,

I want to make one code behind method should return google chart as 
response.
Can we do that?

Thanks
Natarajan Govindavel.

On Thursday, March 10, 2016 at 8:13:18 PM UTC+5:30, Sergey wrote:
>
> Natarajan,
>
> As I've said in an earlier email, you should only include /jsapi if you 
> use a GeoChart, and it doesn't appear that you do, so you should not 
> include it at all.
>
> Remember, that with the new loader, you need to do: google.*charts*.load 
> and google.*charts*.setOnLoadCallback.
>
> On Thu, Mar 10, 2016 at 9:15 AM natarajan govindavel  > wrote:
>
>>  Hi Sergey,
>>>
>>>  I tried your solution which is working fine in Firefox and Chrome but 
>>> Not in IE (checked with IE10,IE9,IE8,IE7).
>>>  It produce same issue . SCRIPT5007: Unable to get property 
>>> 'arrayToDataTable' of undefined or null reference.
>>>
>> I am using both classical and material charts on same page. should i 
>> include both library? 
>> https://www.google.com/jsapi
>> ">
>> https://www.gstatic.com/charts/loader.js";>
>> google.setOnLoadCallback(function() {
>> dataArray[0] = 
>> google.visualization.arrayToDataTable([['Status','Count'],['Open',183],['Closed',32]]);TitleArray[0]
>>  
>> = 'Incident Status';;
>> if (typeof dataArray[0] != "undefined") {
>> // Array dynamically generated from code behind   
>>  
>> var options = {
>> width: '100%',
>> height: 400,
>> titlePosition: 'none',//hiding the chart title
>> legend: {
>> position: 'bottom' //fix legend in bottom 
>> },
>> is3D: true
>> };
>> var colors = new Array()
>> for (var i = 0; i < dataArray[0].getNumberOfRows(); 
>> i++) {
>> if (dataArray[0].getValue(i, 0) == "Open")
>> colors[i] = '#DB4437';
>> else if (dataArray[0].getValue(i, 0) == "Closed")
>> colors[i] = '#3FC380';
>> else if (dataArray[0].getValue(i, 0) == "Incident 
>> Disposition")
>> colors[i] = '#F9BF3B';
>> }
>> options.colors = colors;
>> $('#status').text(TitleArray[0]);
>> drawChart('Pie', dataArray[0], 'div_id_1', options);
>> }
>> });
>>
>>
>>  
>>
>>>  Thanks
>>>  Natarajan
>>>
>>>
>>> On Tuesday, March 8, 2016 at 8:22:16 PM UTC+5:30, Sergey wrote:
>>>
>>> It sounds like you're not putting your chart code into a callback. That 
>>> is, you're probably doing something like:
>>> 
>>> 
>>> var data = google.visualization.arrayToDataTable(...);
>>> // more chart stuff
>>> 
>>>
>>> When you should be doing:
>>> ...
>>> 
>>> google.charts.load(...);
>>> google.charts.setOnLoadCallback(drawChart);
>>>
>>> function drawChart() {
>>>   var data = google.visualization.arrayToDataTable(...);
>>>   // more chart stuff
>>> }
>>> 
>>>
>>> On Tue, Mar 8, 2016 at 1:50 AM natarajan govindavel  
>>> wrote:
>>>
>>>
>>> Hi Sergey,
>>>
>>> If i remove jsapi loader code as you said i faced the following issue.
>>>
>>> https://www.gstatic.com/charts/loader.js";>
>>> <%-- https://www.google.com/jsapi?autoload={
>>> 'modules':[{
>>>   'name':'visualization',
>>>   'version':'1.1',
>>>   'packages':['corechart','bar','controls']
>>> }]
>>>   }">--%>
>>>  google.charts.load('current', {
>>> 'packages': ['corechart','bar', 'controls']
>>> });
>>> it shows the error message. Uncaught TypeError: Cannot read property 
>>> 'arrayToDataTable' of undefined.
>>> In the visualization charts not loaded.
>>>
>>> Thanks
>>> Natarajan
>>>
>>> On Monday, March 7, 2016 at 8:39:37 PM UTC+5:30, Sergey wrote:
>>>
>>> Natarajan,
>>>
>>> *Please do not use autoload and the gstatic loader on the same page*. 
>>> This can lead to issues that are very difficult to figure out.
>>>
>>> The gstatic loader is the only place where we're pushing new versions at 
>>> this point. Loading jsapi as well will cause older versions to be loaded. 
>>> The gstatic loader should be the only loader you use at this point (this 
>>> means you should remove the jsapi script entirely, unless you use the 
>>> GeoChart, in which case you still should not have it autoload). You need to 
>>> add 'corechart' to your google.charts.load call though.
>>>
>>> Sadly, there is currently no way to hide an axis in Material Charts.
>>>
>>> On Mon, Mar 7, 2016 at 7:59 AM natarajan govindavel  
>>> wrote:
>>>
>>> I forget to mention one thing. The below given chart is material chart.
>>>
>>>
>>> On Monday, March 7, 2016 at 5:02:37 PM UTC+5:30, natarajan