[visualization-api] datetime format in Google Charts (Areachart)

[Tijger Visuals]

Hello,


i've tried a lot of different formats but somehow cannot seem to get the 
datetime format right for an area-chart in google charts.

As soon as i set the column to 'string' everything works, but i feel like i 
should use datetime.

The data-array is supplied by a php-include that reads from a MySQL 
database and i should be able to create anything you feed me ;)


Thanx for reading (and possibly helping me).




-- 
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/6b39330f-eb44-4e26-8a19-f95be432ddbc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Re: Google Charts title/alt SEO? Will it be indexed well as an image file?

[Eden Dro]

Anyone??

On Thursday, September 24, 2015 at 8:42:19 PM UTC+3, Eden Dro wrote:
>
> Hi people
>
> Currently playing with Google charts and NVD3. I know that google (and 
> others) index inline SVG images, but how to I take care of the basic SEO 
> like title/alt? 
> Can it be done? Will the built-in title of google charts will be used for 
> that?
>
> 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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/0147ee24-3a31-4c14-bcdb-6bef96f73317%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Re: ComboChart vAxes title and max values

[mark m]

Thanks Daniel!

On Friday, October 9, 2015 at 12:23:05 PM UTC-5, mark m wrote:
>
> Starting with the jfiddle example for a combo chart I modified the format 
> to show 2 vertical axes here 
> ...
>
> But I cant get the axis title or max values to behave ...
>
>   google.setOnLoadCallback(drawVisualization);
>
>   function drawVisualization() {
> // Some raw data (not necessarily accurate)
> var data = google.visualization.arrayToDataTable([
>  ['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua New Guinea', 
> 'Rwanda', 'Percent'],
>  ['2004/05',  165,  938, 522, 
> 998,   450,  20],
>  ['2005/06',  135,  1120,599, 
> 1268,  288,  30],
>  ['2006/07',  157,  1167,587, 
> 807,   397,  55],
>  ['2007/08',  139,  1110,615, 
> 968,   215,  68],
>  ['2008/09',  136,  691, 629, 
> 1026,  366,  45]
>   ]);
>
> var options = {
>   title : 'Monthly Coffee Production by Country',
>   //vAxis: {title: 'Cups'},
>   hAxis: {title: 'Month'},
>   seriesType: 'bars',
>   series: {5: {targetAxisIndex:1,type: 'line'}},
>   *vAxes: [{0:{title: "cups", viewWindow:{ min:0.0, max: 
> 1400.0}}},{1:{title: "Pct", viewWindow:{ min:0.0, max: 100.0}}}],*
> };
>
> var chart = new 
> google.visualization.ComboChart(document.getElementById('chart_div'));
> chart.draw(data, options);
>   }
>
> Any ideas?
>
> 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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/fc823a38-c46c-4ee7-b89e-60f95845c6cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Spreadsheets - Selecting rows by column input with two digits (one number and one letter)

[naoterefugies]

Hi..

  I am having some moving spreadsheet data to a different tab, when 
selecting rows according to input in a certain column; this input is made 
of a 2 digit figure with a Capital letter and  a number (something like M3, 
F4, X5, etc..);

  I initially tried the template "fill-in the blank"-style with no success 
and changed over to "basic query" - still nothing worked;
   I've tried back-quotes, single quotes, triple double quotes with no 
success;  

Something like:

=if(Len (B1)=0, "Inserir nº Caixa pf/Please insert Box nr em B1",query('Armazem 
Total'!A2:R,"Select * Where B="&" "))

which worked fine for single numbers..

Then I tried this:

=if(Len (B1)=0, "Inserir nº Caixa pf/Please insert Box nr em B1",query('Armazem 
Total'!A2:R,"Select * Where B="""&""" "))

then this

=if(query('Armazem Total'!A2:R,"Select * Where B="'&'" "))

and

=if(query('Armazem Total'!A2:R,"Select * Where B="`&`" "))

Then simplified to: 

=query(!A1:F7, "Select * where B=`2F`")

And no luck so far.

Any ideas?

 Thanks!!

   b.

-- 
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/9174f051-cbae-4fa6-91bc-bbe12eaf9594%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: Google Charts title/alt SEO? Will it be indexed well as an image file?

['Jon Orwant' via Google Visualization API]

We don't (and in fact, *can't*) give SEO assistance, sorry.

Jon

On Mon, Oct 12, 2015 at 12:47 PM, Eden Dro  wrote:

> Anyone??
>
> On Thursday, September 24, 2015 at 8:42:19 PM UTC+3, Eden Dro wrote:
>>
>> Hi people
>>
>> Currently playing with Google charts and NVD3. I know that google (and
>> others) index inline SVG images, but how to I take care of the basic SEO
>> like title/alt?
>> Can it be done? Will the built-in title of google charts will be used for
>> that?
>>
>> 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
> http://groups.google.com/group/google-visualization-api.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/google-visualization-api/0147ee24-3a31-4c14-bcdb-6bef96f73317%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAJs5hDa_h6OLqzrUT%3Dn2B%2Bo5dzyZs0CHK%3DTLCEb%3D%3DQPc4YpPQw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: Google Charts title/alt SEO? Will it be indexed well as an image file?

['Jon Orwant' via Google Visualization API]

Google Web Search and Image Search decide for themselves how they rank
search results. Owners of Google Services such as Google Charts have no
influence over how they do that, and our knowledge of how they do that is
quite limited.

There are plenty of third party sites that will advise you on how to
optimize your web site for Google, but I'm unaware of any that talk about
Google Charts. (Then again, I haven't looked!) I can say only that it would
make sense for a search engine to pay attention to the language in the
titles and axes of a chart.

My apologies for an answer that is both unhelpful ("I don't know and
couldn't tell you even if I did") and meta-unhelpful ("I can't even tell
you where to go to answer your question"). I tried to be
meta-meta-unhelpful by not answering in the first place, but guilt got the
better of me.

Jon


On Mon, Oct 12, 2015 at 12:57 PM, Eden Dro  wrote:

> Thanks Jon, but please explain..
> where should I ask? the indexing of google charts by google should be
> related to the way you are using it, not to SEO in general
>
> On Monday, October 12, 2015 at 7:55:38 PM UTC+3, orw...@google.com wrote:
>>
>> We don't (and in fact, *can't*) give SEO assistance, sorry.
>>
>> Jon
>>
>> On Mon, Oct 12, 2015 at 12:47 PM, Eden Dro  wrote:
>>
>>> Anyone??
>>>
>>> On Thursday, September 24, 2015 at 8:42:19 PM UTC+3, Eden Dro wrote:

 Hi people

 Currently playing with Google charts and NVD3. I know that google (and
 others) index inline SVG images, but how to I take care of the basic SEO
 like title/alt?
 Can it be done? Will the built-in title of google charts will be used
 for that?

 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-visua...@googlegroups.com.
>>> Visit this group at
>>> http://groups.google.com/group/google-visualization-api.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/google-visualization-api/0147ee24-3a31-4c14-bcdb-6bef96f73317%40googlegroups.com
>>> 
>>> .
>>>
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> 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
> http://groups.google.com/group/google-visualization-api.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/google-visualization-api/6bc04e2d-5af6-4391-bcc1-b6b0cdc2081e%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAJs5hDaOMURLPSYgSqAgW1KY%3Dmn_NAoSFLg7sFkCVs8_%2Bem0jQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: Google Charts title/alt SEO? Will it be indexed well as an image file?

[Eden Dro]

Thanks Jon, but please explain..
where should I ask? the indexing of google charts by google should be 
related to the way you are using it, not to SEO in general

On Monday, October 12, 2015 at 7:55:38 PM UTC+3, orw...@google.com wrote:
>
> We don't (and in fact, *can't*) give SEO assistance, sorry.
>
> Jon
>
> On Mon, Oct 12, 2015 at 12:47 PM, Eden Dro  > wrote:
>
>> Anyone??
>>
>> On Thursday, September 24, 2015 at 8:42:19 PM UTC+3, Eden Dro wrote:
>>>
>>> Hi people
>>>
>>> Currently playing with Google charts and NVD3. I know that google (and 
>>> others) index inline SVG images, but how to I take care of the basic SEO 
>>> like title/alt? 
>>> Can it be done? Will the built-in title of google charts will be used 
>>> for that?
>>>
>>> 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-visua...@googlegroups.com 
>> .
>> Visit this group at 
>> http://groups.google.com/group/google-visualization-api.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/google-visualization-api/0147ee24-3a31-4c14-bcdb-6bef96f73317%40googlegroups.com
>>  
>> 
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/6bc04e2d-5af6-4391-bcc1-b6b0cdc2081e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: Google Charts title/alt SEO? Will it be indexed well as an image file?

[Eden Dro]

Well, I won't even tell you if I meta lolled or not
Thanks for the computation power invested in this reply

On Monday, October 12, 2015 at 8:11:08 PM UTC+3, orw...@google.com wrote:
>
> Google Web Search and Image Search decide for themselves how they rank 
> search results. Owners of Google Services such as Google Charts have no 
> influence over how they do that, and our knowledge of how they do that is 
> quite limited. 
>
> There are plenty of third party sites that will advise you on how to 
> optimize your web site for Google, but I'm unaware of any that talk about 
> Google Charts. (Then again, I haven't looked!) I can say only that it would 
> make sense for a search engine to pay attention to the language in the 
> titles and axes of a chart.
>
> My apologies for an answer that is both unhelpful ("I don't know and 
> couldn't tell you even if I did") and meta-unhelpful ("I can't even tell 
> you where to go to answer your question"). I tried to be 
> meta-meta-unhelpful by not answering in the first place, but guilt got the 
> better of me.
>
> Jon
>
>
> On Mon, Oct 12, 2015 at 12:57 PM, Eden Dro  > wrote:
>
>> Thanks Jon, but please explain..
>> where should I ask? the indexing of google charts by google should be 
>> related to the way you are using it, not to SEO in general
>>
>> On Monday, October 12, 2015 at 7:55:38 PM UTC+3, orw...@google.com wrote:
>>>
>>> We don't (and in fact, *can't*) give SEO assistance, sorry.
>>>
>>> Jon
>>>
>>> On Mon, Oct 12, 2015 at 12:47 PM, Eden Dro  wrote:
>>>
 Anyone??

 On Thursday, September 24, 2015 at 8:42:19 PM UTC+3, Eden Dro wrote:
>
> Hi people
>
> Currently playing with Google charts and NVD3. I know that google (and 
> others) index inline SVG images, but how to I take care of the basic SEO 
> like title/alt? 
> Can it be done? Will the built-in title of google charts will be used 
> for that?
>
> 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-visua...@googlegroups.com.
 Visit this group at 
 http://groups.google.com/group/google-visualization-api.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/google-visualization-api/0147ee24-3a31-4c14-bcdb-6bef96f73317%40googlegroups.com
  
 
 .

 For more options, visit https://groups.google.com/d/optout.

>>>
>>> -- 
>> 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-visua...@googlegroups.com 
>> .
>> Visit this group at 
>> http://groups.google.com/group/google-visualization-api.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/google-visualization-api/6bc04e2d-5af6-4391-bcc1-b6b0cdc2081e%40googlegroups.com
>>  
>> 
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/06b11a19-dab1-4d63-911d-2995491a2993%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Annotation Charts - How to display change of value in current display as a percentage?

[Ray]

How can I display the change in value of the selected time range as a 
percentage on the chart, similar to how Google Finance charts display it:



-- 
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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/9cf2ebfa-e1c5-479e-a939-b6775e30a29e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] datetime format in Google Charts (Areachart)

['Daniel LaLiberte' via Google Visualization API]

Hi

Your datetime values are actually strings that would have to be parsed, but
the parsing turns out to be problematic.  You should read up on dates and
times for Google Charts on this page:
https://developers.google.com/chart/interactive/docs/datesandtimes


On Mon, Oct 12, 2015 at 3:20 AM, Tijger Visuals 
wrote:

> Hello,
>
>
> i've tried a lot of different formats but somehow cannot seem to get the
> datetime format right for an area-chart in google charts.
>
> As soon as i set the column to 'string' everything works, but i feel like
> i should use datetime.
>
> The data-array is supplied by a php-include that reads from a MySQL
> database and i should be able to create anything you feed me ;)
>
>
> Thanx for reading (and possibly helping me).
>
>
>
> 
>
> --
> 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
> http://groups.google.com/group/google-visualization-api.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/google-visualization-api/6b39330f-eb44-4e26-8a19-f95be432ddbc%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte   -
978-394-1058
dlalibe...@google.com    5CC, Cambridge MA
daniel.lalibe...@gmail.com  9 Juniper Ridge
Road, Acton 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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJN8L69nVEn4wnTzgRrOOxpg5%2Bn8YDmWdHvh-NNk4r0saw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Annotation Charts - How to display change of value in current display as a percentage?

['Daniel LaLiberte' via Google Visualization API]

Ray,

We don't have that option in the AnnotationChart yet.  It's a good idea,
and we will probably get around to implementing it next time we are working
that area.

On Mon, Oct 12, 2015 at 10:03 PM, Ray  wrote:

> How can I display the change in value of the selected time range as a
> percentage on the chart, similar to how Google Finance charts display it:
>
>
> 
>
> --
> 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
> http://groups.google.com/group/google-visualization-api.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/google-visualization-api/9cf2ebfa-e1c5-479e-a939-b6775e30a29e%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte   -
978-394-1058
dlalibe...@google.com    5CC, Cambridge MA
daniel.lalibe...@gmail.com  9 Juniper Ridge
Road, Acton 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 http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJOrahWKAs%2BBPWH_wVeb5yAQjYqkuX7Wb65SG44ZfRP7VQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.