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

[natarajan govindavel]

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 govindavel 
> wrote:
>
> Hi Sergey,
>
> Thank so much for your support. Almost fixed all the issues except one.
> Is their anyway to hiding these (highlighted) supplementary axis from the 
> chart.
>
>
> 
>
> Thanks
> Natarajan Govindavel
>
> On Wednesday, February 24, 2016 at 9:31:59 PM UTC+5:30, Sergey wrote:
>
> Hi Natarajan,
>
> You should be able to use html2canvas to save the charts as images, as the 
> stackoverflow post suggests. You may be aware that some of our charts (like 
> ComboChart and the rest of the charts provided by the 'corechart' package) 
> support getImageUri, which will basically allow you to save images of the 
> charts, but Material Charts do not yet support this API.
>
> On Wed, Feb 24, 2016 at 10:26 AM natarajan govindavel  
> wrote:
>
> Hi Sergey,
>
> Is there any other way to save material chart as images.
> like given in that link : 
> http://stackoverflow.com/questions/6887183/how-to-take-screen-shot-of-a-div-with-javascript
>
> Thanks
> Natarajan Govidavel
>
>
> On Friday, February 19, 2016 at 8:43:59 PM UTC+5:30, Sergey wrote:
>
> So I don't see anything obviously wrong with your code. Could you link to 
> a page on which you're experiencing the error? If you're uncomfortable 
> sharing the link over the forum, feel free to send me a private message.
>
> On Fri, Feb 19, 2016 at 8:47 AM natarajan govindavel  
> wrote:
>
> Hi sergey,
>
> I have seen  below mentioned issue in browser console
> Error: one or more fonts could not be loaded.
>
> In FireFox (44.0.2) this issue happen more frequently.
> And I checked with the link 
>
> https://groups.google.com/forum/#!topic/google-visualization-api/bSJLBO_fm2w
>
> so i changed from current to 43 still issue exists.
> And my code is very complex because making the array dynamically from 
> webservice (asmx) and calling that data using jquery ajax.
>
> function ChangePeriodL(id) {
> if (id != "") {
> $(".loc").removeClass('active');
> $(id).addClass('active');
> value = $(id).attr('id');
> event_id = "CLICK"; //click event
> g_var = 0;
> } else
> value = 0;
> $.ajax({
> type: "POST",
> url: "remote url",
> contentType: "application/json; charset=utf-8",
> dataType: "json",
> data: JSON.stringify({
> "timespan": value
> }),
> success: function(data) {
> if (data.d != "Empty") {
> addCode(data.d);
> if (typeof dataArray[8] != "undefined") {
> $('#AllLoc').text(TitleArray[8]);
> if (dataArray[8].getNumberOfRows() > 3)
> var height = dataArray[8].getNumberOfRows() * 40 + 
> 100; //Set dynamic height = Number of Rows * bar + padding
> else
> var height = 300;
>
> $('#div_id_9').height(height);
> var chartnew = new 
> google.charts.Bar(document.getElementById('div_id_9'));
> chartnew.draw(dataArray[8], 
> google.charts.Bar.convertOptions({
> width: 1000,
> height: '100%',
> titlePosition: 'none', //hiding chart title 
> legend: {
> po

[visualization-api] Facing problem with information box on hover of any bar drawn in chart

[Abhijit Dhobale]

Hello Team,

I draw a Gantt chart but facing problem with information box which is 
occurred on hover of any bar. I attached 2 image with this post. PFA. I 
also want to exclude weekends from the chart so is it possible? Thanks in 
advance for your help.


Thanks, 
Abhijit

-- 
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/7504a6b5-df44-4bca-85f3-0243d63478b8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Google Stacked Group Chart , Need Clustered stacked columns using google chart only

[Ravi Kanje]

Hi Daniel 


Thanks for your reply, I took a look on that graph, but it shows the column 
graphs in clustered , however i need a *clustered stacked column graphs* , 
not just clustered column graph . Please have a look on my attachment 
picture. Please suggest me is there any alternative to produce the graph 
same as in attachment

On Monday, 7 March 2016 22:55:31 UTC+8, Daniel LaLiberte wrote:
>
> Hi Ravi,
>
> You can do that type of stacked and grouped chart with the Material Column 
> Chart.   The trick is to target all of the series that should be stacked 
> together to its own axis.
> See:   
> https://developers.google.com/chart/interactive/docs/gallery/columnchart#creating-material-column-charts
>
>
> On Sun, Mar 6, 2016 at 9:08 PM, Ravi Kanje  > wrote:
>
>> Hi All,
>>
>> Can anyone help me in drawing the google stacked column chart as 
>> attached. I am able to produce column chart but the issue is i am not able 
>> to clustered stacked columns based on the X-Axis  monthly data.
>>
>> I want to group the stacked column chart based on month so that i can 
>> cluster the columns horizontally as shown in attached pic.
>>
>>
>> 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 
>> 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/dc7530a1-23a9-4e89-a4c3-1d6afd0c57d4%40googlegroups.com
>>  
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Daniel LaLiberte 
> dlali...@google.com5CC, 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/0e30298f-e186-4180-956a-1be8d3ed6a52%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Oval - Bubble Chart

[josephvijoe]

Hi All,

Currenty I am using bubble chart for my project. But I would like to 
replace bubbles with oval or ellipse with different radii. Is there a way 
possible to do this using google api or is there a possible work around ?

Regards,
Joseph

-- 
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/2d5678d8-a276-4fc3-9533-38b7e9049846%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Maps: Support for drawing markers and regions on the same map.

[Nathan Meryash]

I like the DataTable concept you've presented a lot; this is simple and 
flexible.

-Nathan

On Monday, March 7, 2016 at 4:48:36 PM UTC-5, Sergey wrote:
>
> We did in fact consider layers. However, if we were to do layers, we would 
> have to do it in a way that is applicable for all charts (so that we 
> maintain a consistent API). One of the issues that your API design has is 
> that it would make layers inaccessible via ChartWrapper and Dashboard. 
> Another issue is that we wouldn't know how many layers to create without 
> another signal to the chart (i.e. chart.setLayers(2)), or always provide 
> some N layers. This also makes the chart not serializable, since there 
> exists some state that is defined outside of the DataTable and options.
>
> Generally, we try to steer away from adding new functions/properties to 
> our charts (although we've made compromises in this direction with adding 
> getImageUri() and setAction()).
>
> In my opinion, the most sensible way to add what you're asking for would 
> be to have fully composable charts (i.e. have a polygon layer and a markers 
> layer, but this could be applied to any chart). We've been pondering this 
> approach, but it's something that would require a complete overhaul of our 
> implementation.
>
> The next most sensible option (in terms of fitting into the constraints of 
> the existing API) is to have a combined DataTable Format that allows you to 
> specify either a region or a lat/long, something like:
> [Region Code] | [Latitude] | [Longitude] | [Location Name] | [Value 1] | 
> [Value 2] | [Display Type]
>
> With certain columns being optional (like "Location Name", "Value 1" and 
> "Value 2"). This would allow you to specify 'null' for the region code 
> where you specify lat/long, or "Region Code" could be an address if 
> "Display Type" is 'markers' or 'text'. "Location Name" would apply to 
> either lat/long or region code. "Value 1" would map to the color of the 
> data, and "Value 2" would map to the size of the marker/text. "Display 
> Type" would be one of "region", "marker", "text", or null (to take the 
> current 'displayType').
>
> I feel that this approach allows the best interoperability with our 
> current APIs and utilities, without adding too many new features, and still 
> maintaining clear control over how things are rendered. This method would 
> also allow users to draw marker data from both addresses and lat/long 
> coordinates.
>
> On Mon, Mar 7, 2016 at 4:23 PM Nathan Meryash  > wrote:
>
>> Hi Sergey,
>>
>> Thank you for the quick and comprehensive response. It's encouraging to 
>> know thought has been made here and to understand the challenges you face 
>> balancing a number of objectives.
>>
>> Have you considered adding support for layers, perhaps as children to a 
>> chart object? Syntax wise, something like the following with the ability to 
>> define layer order and blending properties (not shown):
>>
>> chart.layer1.draw(regionsData, regionsOptions);
>> chart.layer2.draw(markersData, markersOptions);
>>
>> Regards,
>>
>> Nathan
>>
>>
>> On Monday, March 7, 2016 at 9:56:44 AM UTC-5, Sergey wrote:
>>
>>> Hi Nathan,
>>>
>>> We have talked internally at length about combining the different ways 
>>> of rendering the GeoChart, and have thought long and hard about how to do 
>>> this. We eventually chose to punt on this issue.
>>>
>>> Personally, I don't like the idea of passing an array of things to 
>>> chart.draw very much, since that results in an inconsistent API, and this 
>>> is one of the things many of the users of our API (including our own 
>>> Controls and Dashboards) depend on. Adding a new form of arguments to 
>>> chart.draw would make things more complicated and confusing in that 
>>> respect. Our preference would be to either specify this information in one 
>>> DataTable or via options, but we were not able to decide on a consistent 
>>> way to do this.
>>>
>>> The Goole Maps API vs Charts is a much deeper issue than I'd like to get 
>>> into here, but suffice it to say that these two APIs are developed by 
>>> different teams, that ultimately have different goals and use cases.
>>>
>>> On Sun, Mar 6, 2016 at 12:28 PM Nathan Meryash  
>>> wrote:
>>>
>> It would be great if the chart.draw() method supported arrays so that one 
 could draw regions and markers on the same map. It seems necessary as one 
 needs to call different options arguments for regions and markers. 
 Especially the displayMode.

 Example:

 chart.draw([
   [regionsData, regionsOptions],
   [markersData, markersOptions]
 ]);

 You called the draw() method with an Array rather than a DataTable or 
 DataView

 It's also not clear why Google Maps Javascript API 
 and 
 Charts 
  
 aren't consolidated into one full featured API?

Re: [visualization-api] Maps: Support for drawing markers and regions on the same map.

['Sergey Grabkovsky' via Google Visualization API]

We did in fact consider layers. However, if we were to do layers, we would
have to do it in a way that is applicable for all charts (so that we
maintain a consistent API). One of the issues that your API design has is
that it would make layers inaccessible via ChartWrapper and Dashboard.
Another issue is that we wouldn't know how many layers to create without
another signal to the chart (i.e. chart.setLayers(2)), or always provide
some N layers. This also makes the chart not serializable, since there
exists some state that is defined outside of the DataTable and options.

Generally, we try to steer away from adding new functions/properties to our
charts (although we've made compromises in this direction with adding
getImageUri() and setAction()).

In my opinion, the most sensible way to add what you're asking for would be
to have fully composable charts (i.e. have a polygon layer and a markers
layer, but this could be applied to any chart). We've been pondering this
approach, but it's something that would require a complete overhaul of our
implementation.

The next most sensible option (in terms of fitting into the constraints of
the existing API) is to have a combined DataTable Format that allows you to
specify either a region or a lat/long, something like:
[Region Code] | [Latitude] | [Longitude] | [Location Name] | [Value 1] |
[Value 2] | [Display Type]

With certain columns being optional (like "Location Name", "Value 1" and
"Value 2"). This would allow you to specify 'null' for the region code
where you specify lat/long, or "Region Code" could be an address if
"Display Type" is 'markers' or 'text'. "Location Name" would apply to
either lat/long or region code. "Value 1" would map to the color of the
data, and "Value 2" would map to the size of the marker/text. "Display
Type" would be one of "region", "marker", "text", or null (to take the
current 'displayType').

I feel that this approach allows the best interoperability with our current
APIs and utilities, without adding too many new features, and still
maintaining clear control over how things are rendered. This method would
also allow users to draw marker data from both addresses and lat/long
coordinates.

On Mon, Mar 7, 2016 at 4:23 PM Nathan Meryash  wrote:

> Hi Sergey,
>
> Thank you for the quick and comprehensive response. It's encouraging to
> know thought has been made here and to understand the challenges you face
> balancing a number of objectives.
>
> Have you considered adding support for layers, perhaps as children to a
> chart object? Syntax wise, something like the following with the ability to
> define layer order and blending properties (not shown):
>
> chart.layer1.draw(regionsData, regionsOptions);
> chart.layer2.draw(markersData, markersOptions);
>
> Regards,
>
> Nathan
>
>
> On Monday, March 7, 2016 at 9:56:44 AM UTC-5, Sergey wrote:
>
>> Hi Nathan,
>>
>> We have talked internally at length about combining the different ways of
>> rendering the GeoChart, and have thought long and hard about how to do
>> this. We eventually chose to punt on this issue.
>>
>> Personally, I don't like the idea of passing an array of things to
>> chart.draw very much, since that results in an inconsistent API, and this
>> is one of the things many of the users of our API (including our own
>> Controls and Dashboards) depend on. Adding a new form of arguments to
>> chart.draw would make things more complicated and confusing in that
>> respect. Our preference would be to either specify this information in one
>> DataTable or via options, but we were not able to decide on a consistent
>> way to do this.
>>
>> The Goole Maps API vs Charts is a much deeper issue than I'd like to get
>> into here, but suffice it to say that these two APIs are developed by
>> different teams, that ultimately have different goals and use cases.
>>
>> On Sun, Mar 6, 2016 at 12:28 PM Nathan Meryash 
>> wrote:
>>
> It would be great if the chart.draw() method supported arrays so that one
>>> could draw regions and markers on the same map. It seems necessary as one
>>> needs to call different options arguments for regions and markers.
>>> Especially the displayMode.
>>>
>>> Example:
>>>
>>> chart.draw([
>>>   [regionsData, regionsOptions],
>>>   [markersData, markersOptions]
>>> ]);
>>>
>>> You called the draw() method with an Array rather than a DataTable or
>>> DataView
>>>
>>> It's also not clear why Google Maps Javascript API
>>> and Charts
>>> 
>>> aren't consolidated into one full featured API?
>>>
>>> There are also partially featured custom Maps in Google Maps and Google
>>> Sheets, it would be great to have more features by combining these two.
>>>
>>> --
>>> 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 i

Re: [visualization-api] Maps: Support for drawing markers and regions on the same map.

[Nathan Meryash]

Hi Sergey,

Thank you for the quick and comprehensive response. It's encouraging to 
know thought has been made here and to understand the challenges you face 
balancing a number of objectives.

Have you considered adding support for layers, perhaps as children to a 
chart object? Syntax wise, something like the following with the ability to 
define layer order and blending properties (not shown):

chart.layer1.draw(regionsData, regionsOptions);
chart.layer2.draw(markersData, markersOptions);

Regards,

Nathan


On Monday, March 7, 2016 at 9:56:44 AM UTC-5, Sergey wrote:
>
> Hi Nathan,
>
> We have talked internally at length about combining the different ways of 
> rendering the GeoChart, and have thought long and hard about how to do 
> this. We eventually chose to punt on this issue.
>
> Personally, I don't like the idea of passing an array of things to 
> chart.draw very much, since that results in an inconsistent API, and this 
> is one of the things many of the users of our API (including our own 
> Controls and Dashboards) depend on. Adding a new form of arguments to 
> chart.draw would make things more complicated and confusing in that 
> respect. Our preference would be to either specify this information in one 
> DataTable or via options, but we were not able to decide on a consistent 
> way to do this.
>
> The Goole Maps API vs Charts is a much deeper issue than I'd like to get 
> into here, but suffice it to say that these two APIs are developed by 
> different teams, that ultimately have different goals and use cases.
>
> On Sun, Mar 6, 2016 at 12:28 PM Nathan Meryash  > wrote:
>
>> It would be great if the chart.draw() method supported arrays so that one 
>> could draw regions and markers on the same map. It seems necessary as one 
>> needs to call different options arguments for regions and markers. 
>> Especially the displayMode.
>>
>> Example:
>>
>> chart.draw([
>>   [regionsData, regionsOptions],
>>   [markersData, markersOptions]
>> ]);
>>
>> You called the draw() method with an Array rather than a DataTable or 
>> DataView
>>
>> It's also not clear why Google Maps Javascript API 
>> and Charts 
>>  
>> aren't consolidated into one full featured API?
>>
>> There are also partially featured custom Maps in Google Maps and Google 
>> Sheets, it would be great to have more features by combining these two.
>>
>> -- 
>> 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 
>> 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/a9a2de6c-3014-4952-acc6-2c49fca4188d%40googlegroups.com
>>  
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
> -- 
>
> *[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc• 
> gra...@google.com *
>
>

-- 
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/97f5a581-5d1e-4fe5-97b2-c9584419%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Chart calendar issue

[Fernando Gandini]

Any one have a clue why my chart shows all "non data block" and "colorAxis" 
in black?
Since change the version of google charts i have this problem.



Here is what i set as options:


var options = {

 legend: { position: 'bottom' },

 colorAxis: {colors:['#af','#63ace5']},

 height: getGraphSize(this.inFocusUser),

 calendar: {   

 cellSize: 13, 

 cellColor: {

 opacity: 0

 },

 monthOutlineColor: {

 strokeOpacity: 0.0,

 strokeWidth: 2

 },

 unusedMonthOutlineColor: {

 strokeOpacity: 0.0,

 strokeWidth: 1

 },

 yearLabel: { 

 fontSize: 20,

 color: '#c9c9c9',

 }

 }

 };




And my enteire code is here:


https://github.com/fgandini/Bitbucket-Dashboard


Tanks guys.






-- 
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/3bdb78ab-d6b0-4eac-8985-4644960f435a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Problem plotting duration with google chart

[Hitesh Jain]

Hi Dan

>>  In the meantime, you can include a day number in the format to at least
make the values be distinct and correct.
I tried including the day number in the format but it didn't helped. Sheet
is updated to include the day number in the Format as , :

Thanks
Hitesh

On Mon, Mar 7, 2016 at 6:16 AM, 'Daniel LaLiberte' via Google Visualization
API  wrote:

> Hi Hitesh,
>
> The timeofday formatting doesn't currently know how to display values for
> hours outside the normal range of a day since we use the standard Google
> closure date/time formatting utilities that uses a subset of the ICU
> formatting rules documented here:
> http://userguide.icu-project.org/formatparse/datetime . Probably the
> correct solution would be to add a formatting option to indicate you want
> unbounded hours.  The same would apply to each of the other date/time
> units: seconds, milliseconds, minutes, days and months.
>
> In the meantime, you can include a day number in the format to at least
> make the values be distinct and correct.
>
> On Sat, Mar 5, 2016 at 2:32 AM, Hitesh Jain 
> wrote:
>
>> Hi
>>
>> I want to plot data on line chart where each rows corresponds to 1 month
>> and columns contain duration.
>>
>> Following sheet contain sample data and plotted chart.
>>
>> https://docs.google.com/spreadsheets/d/1Dyf0wZ5m4SszDkXuey-0251wZXeXPYMnHFXOgZBjB8o/edit#gid=0
>>
>> I want to plot duration on Y axis such that it starts at 0:00 but in the
>> chart it starts at 16:00 (I think it is doing so because duration more than
>> 24:00 rolls up back to next day). I know this can be solved by making
>> duration a decimal value (like 01:30 can be change to 1.5) but I want data
>> to remain in format hh:mm for better readability. Moreover MS excel plots
>> this correctly (I've attached an image in the document itself)
>>
>>
>> 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/625cf1b3-44b6-47b2-9a9d-ca61a6f9cef6%40googlegroups.com
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Daniel LaLiberte 
> dlalibe...@google.com5CC, Cambridge MA
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Google Visualization API" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/google-visualization-api/qFjRk9VP2Vw/unsubscribe
> .
> To unsubscribe from this group and all its topics, 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/CAOtcSJMA5TFCnF-rQipaaS-PceS%3D-B3h5WFoT%2Brj4_QSxGUapA%40mail.gmail.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 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/CANoxXrg%2BV_YA5e6xa%3DNh%2B%3DY3RWS4s4m8yK8%3Dv6MLbDRypLpumQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Re: line chart unit should be in english not in german

[Nadja]

Thank you very much.
I will try it tomorrow.
I am right, that the API set the language to my location?
If it is like that, it is no problem I only need the units in other 
countries not in german.
Nadja

Am Montag, 7. März 2016 18:33:07 UTC+1 schrieb Nadja:
>
> Hello,
>
> I have a line chart.
> If the numbers are very big, it is shown like this "24Tsd.". but "Tsd." is 
> german, isn't it? How can I change it to english?
> Thank you very much
> Nadja
>

-- 
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/602043a7-a0d4-4fa0-b098-c8920403c7ab%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: line chart unit should be in english not in german

['Sergey Grabkovsky' via Google Visualization API]

The old loader has the capability to set the language based on signals like
your location (although I'm not sure that it actually uses your location),
so yes you're correct: these charts will look different for users in other
locales.

On Mon, Mar 7, 2016 at 1:03 PM Nadja  wrote:

> Thank you very much.
> I will try it tomorrow.
> I am right, that the API set the language to my location?
> If it is like that, it is no problem I only need the units in other
> countries not in german.
> Nadja
>
>
> Am Montag, 7. März 2016 18:33:07 UTC+1 schrieb Nadja:
>
>> Hello,
>>
>> I have a line chart.
>> If the numbers are very big, it is shown like this "24Tsd.". but "Tsd."
>> is german, isn't it? How can I change it to english?
>> Thank you very much
>> Nadja
>>
> --
> 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/602043a7-a0d4-4fa0-b098-c8920403c7ab%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
-- 

*[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc•
gra...@google.com *

-- 
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/CAEwwup6iSdMjCdf3t7z5S9jyvZ6Jn6fTOQuHsQGFmn-MDyUzyw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: line chart unit should be in english not in german

['Sergey Grabkovsky' via Google Visualization API]

It appears to be as I've guessed. You're still using the old loader
(google.load). Please follow the instructions in our documentation
 and
let me know if it helps.

On Mon, Mar 7, 2016 at 12:57 PM Nadja  wrote:

> The code is like this:
>  
> google.load('visualization', '1.1', {packages: ['line']});
> google.setOnLoadCallback(drawChart);
>
> function drawChart() {
>
>   var data = new google.visualization.DataTable();
>   data.addColumn('string', 'Time');
>  if(==1) {data.
> addColumn('number', 'Zone 1');}
>   if(==1){ data.
> addColumn('number', 'Zone 2');}
>   if(==1) {data.
> addColumn('number', 'Zone 3');}
>   if(==1) {data.
> addColumn('number', 'Temp');}
>
>  data.addRows();
>
> //alle WErte
>   if(==1){
>   var options = {
> chart: {
>   title: 'Data'
> },
>
> height:600,
> chartArea:{left:30,top:30,width:'100%',height:600},
> series: {
>   // Gives each series an axis name that matches the Y-axis below.
>
>  0: {axis: 'ppm'},
>  1:{axis: 'ppm'},
>  2:{axis: 'ppm'},
>  3:{axis: 'C'},
>
> },
> axes: {
>   // Adds labels to each axis; they don't have to match the axis
> names.
>  y: {
> ppm: {label: ''},
> C: {label: '°C'}
>
>   }
> }
>
>   };} var chart = new google.charts.Line(document.getElementById(
> 'linechart_material'));
>
>   chart.draw(data, options);
> }
>
> // Make the charts responsive
>   jQuery(document).ready(function(){
> jQuery(window).resize(function(){
>   drawChart();
> });
>   });
>
>   
>
>
>
> Am Montag, 7. März 2016 18:33:07 UTC+1 schrieb Nadja:
>
>> Hello,
>>
>> I have a line chart.
>> If the numbers are very big, it is shown like this "24Tsd.". but "Tsd."
>> is german, isn't it? How can I change it to english?
>> Thank you very much
>> Nadja
>>
> --
> 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/1a1177e8-8c15-4033-804b-2c17a63dcb05%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
-- 

*[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc•
gra...@google.com *

-- 
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/CAEwwup6QBR%2ByiUtQ6HMyDUcUpo3qiAK-sFcTDts%3DJHbdw6Ev1g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Re: line chart unit should be in english not in german

[Nadja]

The code is like this:
 
google.load('visualization', '1.1', {packages: ['line']});
google.setOnLoadCallback(drawChart);

function drawChart() {

  var data = new google.visualization.DataTable();
  data.addColumn('string', 'Time');
 if(==1) {data.
addColumn('number', 'Zone 1');}
  if(==1){ data.
addColumn('number', 'Zone 2');}
  if(==1) {data.
addColumn('number', 'Zone 3');}
  if(==1) {data.
addColumn('number', 'Temp');}
  
 data.addRows();

//alle WErte
  if(==1){  
  var options = {
chart: {
  title: 'Data'
}, 

height:600,
chartArea:{left:30,top:30,width:'100%',height:600},
series: {
  // Gives each series an axis name that matches the Y-axis below.
 
 0: {axis: 'ppm'},
 1:{axis: 'ppm'},
 2:{axis: 'ppm'},
 3:{axis: 'C'},
  
},
axes: {
  // Adds labels to each axis; they don't have to match the axis 
names.
 y: {
ppm: {label: ''},
C: {label: '°C'}

  }
}

  };} var chart = new google.charts.Line(document.getElementById(
'linechart_material'));

  chart.draw(data, options);
}

// Make the charts responsive
  jQuery(document).ready(function(){
jQuery(window).resize(function(){
  drawChart();
});
  });

  



Am Montag, 7. März 2016 18:33:07 UTC+1 schrieb Nadja:
>
> Hello,
>
> I have a line chart.
> If the numbers are very big, it is shown like this "24Tsd.". but "Tsd." is 
> german, isn't it? How can I change it to english?
> Thank you very much
> Nadja
>

-- 
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/1a1177e8-8c15-4033-804b-2c17a63dcb05%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] line chart unit should be in english not in german

['Sergey Grabkovsky' via Google Visualization API]

Hi Nadja,

Could you please post some sample code where you see this issue?

On Mon, Mar 7, 2016 at 12:33 PM Nadja  wrote:

> Hello,
>
> I have a line chart.
> If the numbers are very big, it is shown like this "24Tsd.". but "Tsd." is
> german, isn't it? How can I change it to english?
> Thank you very much
> Nadja
>
> --
> 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/405964a6-3fea-43b0-ba80-63a4ca7cf475%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
-- 

*[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc•
gra...@google.com *

-- 
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/CAEwwup5a7urDZD2c6VwLKt_Lrs0t-UXK-HH3NGPJvuAfczUHXQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: line chart unit should be in english not in german

['Sergey Grabkovsky' via Google Visualization API]

Hi Nadja,

The image is not helpful. But without the code available, I'll attempt to
guess at what's wrong.

Most probably, this issue stems from specifying a language code when
calling .load.

The next most probable reason is that you're using google.load (instead of
google.charts.load) along with the old loader (www.google.com/jsapi), which
will attempt to auto-detect your locale.

I'm afraid I can offer no other guesses without seeing the code.

On Mon, Mar 7, 2016 at 12:50 PM Nadja  wrote:

> The graph is in a proteced area. But I have a image for you.
> I hope it will help.
> Nadja
>
>
> Am Montag, 7. März 2016 18:33:07 UTC+1 schrieb Nadja:
>>
>> Hello,
>>
>> I have a line chart.
>> If the numbers are very big, it is shown like this "24Tsd.". but "Tsd."
>> is german, isn't it? How can I change it to english?
>> Thank you very much
>> Nadja
>>
> --
> 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/6205ab73-01a8-4811-b562-e695741953f9%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
-- 

*[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc•
gra...@google.com *

-- 
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/CAEwwup7BWyyRB7-V9dt8QAwZn88foF%2BaW5SZSX4xp%2BoVbcFmxg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Re: line chart unit should be in english not in german

[Nadja]

The graph is in a proteced area. But I have a image for you.
I hope it will help.
Nadja

Am Montag, 7. März 2016 18:33:07 UTC+1 schrieb Nadja:
>
> Hello,
>
> I have a line chart.
> If the numbers are very big, it is shown like this "24Tsd.". but "Tsd." is 
> german, isn't it? How can I change it to english?
> Thank you very much
> Nadja
>

-- 
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/6205ab73-01a8-4811-b562-e695741953f9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Line chart - Display data-sets depending on other column (if/then)

[Nadja]

Hello,

I have a line chart with data from a database.
In the database I have a column called "error", where numbers or characters 
reflect the error code (e.g. 0=no error, A=Error in size, B=Error in).
If the error is not equal to "0" the data-set for this entry shall not be 
displayed in the graph; there should be a marker for this data-set 
(*/asterix/color-coded/...) to reflect that this data-set has an error.
In principle I need the good old "if/then" function; IF the error-column is 
<>0, THEN display * or whatever...
Can somebody help me, how to fix this with google line charts?
Thank you
Nadja

-- 
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/3a8acaa2-3894-4bd1-8d52-050887d3c3e1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] line chart unit should be in english not in german

[Nadja]

Hello,

I have a line chart.
If the numbers are very big, it is shown like this "24Tsd.". but "Tsd." is 
german, isn't it? How can I change it to english?
Thank you very much
Nadja

-- 
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/405964a6-3fea-43b0-ba80-63a4ca7cf475%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

['Sergey Grabkovsky' via Google Visualization API]

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 govindavel
> wrote:
>
>> Hi Sergey,
>>
>> Thank so much for your support. Almost fixed all the issues except one.
>> Is their anyway to hiding these (highlighted) supplementary axis from the
>> chart.
>>
>>
>> 
>>
>> Thanks
>> Natarajan Govindavel
>>
>> On Wednesday, February 24, 2016 at 9:31:59 PM UTC+5:30, Sergey wrote:
>>
>> Hi Natarajan,
>>
>> You should be able to use html2canvas to save the charts as images, as
>> the stackoverflow post suggests. You may be aware that some of our charts
>> (like ComboChart and the rest of the charts provided by the 'corechart'
>> package) support getImageUri, which will basically allow you to save images
>> of the charts, but Material Charts do not yet support this API.
>>
>> On Wed, Feb 24, 2016 at 10:26 AM natarajan govindavel <
>> natara...@gmail.com> wrote:
>>
>> Hi Sergey,
>>
>> Is there any other way to save material chart as images.
>> like given in that link :
>> http://stackoverflow.com/questions/6887183/how-to-take-screen-shot-of-a-div-with-javascript
>>
>> Thanks
>> Natarajan Govidavel
>>
>>
>> On Friday, February 19, 2016 at 8:43:59 PM UTC+5:30, Sergey wrote:
>>
>> So I don't see anything obviously wrong with your code. Could you link to
>> a page on which you're experiencing the error? If you're uncomfortable
>> sharing the link over the forum, feel free to send me a private message.
>>
>> On Fri, Feb 19, 2016 at 8:47 AM natarajan govindavel 
>> wrote:
>>
>> Hi sergey,
>>
>> I have seen  below mentioned issue in browser console
>> Error: one or more fonts could not be loaded.
>>
>> In FireFox (44.0.2) this issue happen more frequently.
>> And I checked with the link
>>
>> https://groups.google.com/forum/#!topic/google-visualization-api/bSJLBO_fm2w
>>
>> so i changed from current to 43 still issue exists.
>> And my code is very complex because making the array dynamically from
>> webservice (asmx) and calling that data using jquery ajax.
>>
>> function ChangePeriodL(id) {
>> if (id != "") {
>> $(".loc").removeClass('active');
>> $(id).addClass('active');
>> value = $(id).attr('id');
>> event_id = "CLICK"; //click event
>> g_var = 0;
>> } else
>> value = 0;
>> $.ajax({
>> type: "POST",
>> url: "remote url",
>> contentType: "application/json; charset=utf-8",
>> dataType: "json",
>> data: JSON.stringify({
>> "timespan": value
>> }),
>> success: function(data) {
>> if (data.d != "Empty") {
>> addCode(data.d);
>> if (typeof dataArray[8] != "undefined") {
>> $('#AllLoc').text(TitleArray[8]);
>> if (dataArray[8].getNumberOfRows() > 3)
>> var height = dataArray[8].getNumberOfRows() * 40
>> + 100; //Set dynamic height = Number of Rows * bar + padding
>> else
>> var height = 300;
>>
>> $('#div_id_9').height(height);
>> var chartnew = new
>> google.charts.Bar(document.getElementById('div_id_9'));
>> chartnew.draw(dataArray[8],
>> google.charts.Bar.convertOptions({
>> width: 1000,
>> height: '100%',
>> titlePosition: 'none', //hiding chart title
>> legend: {
>> position: 'right' //place chart legend at
>> right side
>> },
>> isStacked: true, //for stacked chart
>> vAxis: {
>> title: "Incident Count",
>> textStyle: {
>> color: 'black'
>> }
>> },
>> hAxis: {
>> title: "Locations",
>> textStyle: {
>> color: 'black'
>> }
>>  

Re: [visualization-api] Maps: Support for drawing markers and regions on the same map.

['Sergey Grabkovsky' via Google Visualization API]

Hi Nathan,

We have talked internally at length about combining the different ways of
rendering the GeoChart, and have thought long and hard about how to do
this. We eventually chose to punt on this issue.

Personally, I don't like the idea of passing an array of things to
chart.draw very much, since that results in an inconsistent API, and this
is one of the things many of the users of our API (including our own
Controls and Dashboards) depend on. Adding a new form of arguments to
chart.draw would make things more complicated and confusing in that
respect. Our preference would be to either specify this information in one
DataTable or via options, but we were not able to decide on a consistent
way to do this.

The Goole Maps API vs Charts is a much deeper issue than I'd like to get
into here, but suffice it to say that these two APIs are developed by
different teams, that ultimately have different goals and use cases.

On Sun, Mar 6, 2016 at 12:28 PM Nathan Meryash  wrote:

> It would be great if the chart.draw() method supported arrays so that one
> could draw regions and markers on the same map. It seems necessary as one
> needs to call different options arguments for regions and markers.
> Especially the displayMode.
>
> Example:
>
> chart.draw([
>   [regionsData, regionsOptions],
>   [markersData, markersOptions]
> ]);
>
> You called the draw() method with an Array rather than a DataTable or
> DataView
>
> It's also not clear why Google Maps Javascript API
> and Charts
> 
> aren't consolidated into one full featured API?
>
> There are also partially featured custom Maps in Google Maps and Google
> Sheets, it would be great to have more features by combining these two.
>
> --
> 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/a9a2de6c-3014-4952-acc6-2c49fca4188d%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
-- 

*[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc•
gra...@google.com *

-- 
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/CAEwwup5jpemRKoJ11MMRe1Qk-wUGsVfPtnihd9xjoyXXuo7ZYw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Google Stacked Group Chart , Need Clustered stacked columns using google chart only

['Daniel LaLiberte' via Google Visualization API]

Hi Ravi,

You can do that type of stacked and grouped chart with the Material Column
Chart.   The trick is to target all of the series that should be stacked
together to its own axis.
See:
https://developers.google.com/chart/interactive/docs/gallery/columnchart#creating-material-column-charts


On Sun, Mar 6, 2016 at 9:08 PM, Ravi Kanje  wrote:

> Hi All,
>
> Can anyone help me in drawing the google stacked column chart as attached.
> I am able to produce column chart but the issue is i am not able to
> clustered stacked columns based on the X-Axis  monthly data.
>
> I want to group the stacked column chart based on month so that i can
> cluster the columns horizontally as shown in attached pic.
>
>
> 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/dc7530a1-23a9-4e89-a4c3-1d6afd0c57d4%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com5CC, 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/CAOtcSJPFyYkQUARNTo7uVpfj9ZgsP_MvT-8XLdbvg1mh5n5ecw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Viewing amounts in national currency of choice

['Daniel LaLiberte' via Google Visualization API]

Hi Markus,

For currencies, usually you will just use numbers, and then specify the
currency in the format.   See
https://developers.google.com/chart/interactive/docs/reference#numberformat
and also the 'format' option for the LineChart:
https://developers.google.com/chart/interactive/docs/gallery/linechart

On Sun, Mar 6, 2016 at 5:01 AM, Markus Weiss  wrote:

> Hello I am new to things Google Charts
> I have a LineChart where I want to display amounts. What must i to  for
> amounts in a currency of my choice to display? My current code is:
>
>  function drawChart() {
>   var data = google.visualization.arrayToDataTable([
> ["Element", "aktueller Betrag in CHF", { role: "style" } ],
> ["PORTOFORTUNA", 300, "#513a43"],
> ["EYES OPEN", 15330, "6f664c"],
> ["GREEN ETHIOPIA", 1330, "74676c"]
>
>   ]);
>
> Thanks for your help
> Markus
>
> --
> 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/92fc8874-62a2-480b-8564-01459d443cda%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com5CC, 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/CAOtcSJPBg6V-fcf356dwbDW5KDJ6zbbE_YYR9hkKOMgnP63bgA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Unable to add 'select' eventlistener to geochart markers inside a chartwrapper

['Daniel LaLiberte' via Google Visualization API]

Hi Ashwin,

I suspect you need to use addOneTimeListener rather than addListener.  The
reason is that a normal listener will be invoked every time the event
occurs, whereas a one-time listener will, as the name suggests, only be
used one time and then removed.  Your 'ready' event handler will therefore
add another 'select' event handler to the chart every time the dashboard
becomes ready, and when a select event occurs, all the handlers that you
attached will be executed.   Hope that helps figure out your problem.

By the way, the GeoMap is deprecated.  You should try to use the GeoChart
instead.

On Sat, Mar 5, 2016 at 8:02 AM, Ashwin Jugurnauth 
wrote:

> I am struggling a bit at the moment with google geochart. I am trying to
> add an event-listener to a geochart which uses markers to display world
> countries, and when the user clicks on a marker, it loads country-specific
> data. My code works well except for the event-listeners. Now, I know that
> when I am using the chartwrapper object I have to add two event listeners,
> one for the dashboard, and one for the chart once the dashboard event
> listener has loaded. I have managed to get my code to work when I use
> regions instead of markers, but for markers I can't get it to work. It
> should be the same event normally, basically 'select' but I can't get it to
> work. I have posted my whole code for you to get the global picture but you
> should probably focus only on the event listeners and the associated
> tableSelectHandler() function. I have tried so far to remove all the code
> in the function and to display only a generic alert but even that won't
> work. Help please ! Many thanks
>
> var script_url = [
>   '/SymphonyAdminPanel/php/SQLSRV/finalshareByCountry.php',
>   '/SymphonyAdminPanel/php/SQLSRV/countryData.php',
>   '/SymphonyAdminPanel/php/salesdata.php'];
> var pn_1_data = null; //pn_1 datatable var pn_1 = null; // pn_1 div var 
> pn_1_filter = null; // pn_1 filter var pn_1_ch = null; // pn_1 chart
> function pn_1_draw() {
>   // Create a dashboard.
>   pn_1 = new google.visualization.Dashboard(document.getElementById('pn_1'));
>
>   // Create a filter for our datatable
>   pn_1_filter = new google.visualization.ControlWrapper({
> 'controlType': 'NumberRangeFilter',
> 'containerId': 'pn_1_filter',
> 'options': {
> 'filterColumnIndex': 1, //Use filterColumIndex here & not 
> filtercolumnIndex
> }
>   });
>
>   // Chart wrapper object
>   pn_1_ch = new google.visualization.ChartWrapper({
>   'chartType' : 'GeoMap',
>   'containerId' : 'pn_1_ch',
>   'options': {
> 'dataMode' : 'markers',
> 'region' : 'world',
> 'fontName': 'Arimo',
> 'width': 900,
> 'height' : 500
>   }
>
>   });
>
>   //We bind the elements to our dashboard
>   pn_1.bind(pn_1_filter, pn_1_ch);
>
>   // Load Json data from server, create datatable & draw charts
>   $.getJSON(script_url[0], function(jresults){
>
>  //We use the datatable declared earlier and assign it our $.getJson 
> object
>  pn_1_data  = new google.visualization.DataTable(jresults.data);
>
>  //We draw the whole dashboard object and its bound elements
>  pn_1.draw(pn_1_data);
>
>  //We add an event listener to our dashboard which adds an event listener 
> to the bound chart
>  google.visualization.events.addListener(pn_1, 'ready', function(){
>
>   google.visualization.events.addListener(pn_1_ch,'select', 
> tableSelectHandler);
>
>  });
>
>
>   });
> };
> function tableSelectHandler(){/*var selectedItem = 
> pn_1_ch.getChart().getSelection()[0];
>   var country = pn_1_data.getValue(selectedItem.row, 2);
>
>   //Set the geochart region to the country selected
>   pn_1_ch.setOption('region',country);
>
>   //Load new JSON data
>   var url_updated = 
> '/SymphonyAdminPanel/php/SQLSRV/countryData.php?&country='+country;
>
>   $.getJSON(url_updated, function(jresults){
>
>  pn_1_data  = new google.visualization.DataTable(jresults.data);
>
>  pn_1.draw(pn_1_data);
>
>   }); */
>   alert('Its working');
> };
>
>
>
> --
> 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/39ee1f62-976e-42bc-8a09-31736d1ae907%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe.

Re: [visualization-api] ChartRangeFilter and BarChart workaround

['Daniel LaLiberte' via Google Visualization API]

Hi Petr,

First, the ColumnChart (which it sounds like you mean rather than BarChart)
does work with continuous x values.   This is mentioned here:
https://developers.google.com/chart/interactive/docs/gallery/columnchart#data-format
though we don't have many examples of how to use it.

But regardless, what you are trying to do with the view option for the
chart range filter and column chart should work.  If you want to put
together an example that shows what you are trying to do, we can look into
it further.  However, you may not want to bother given the above.

Regarding your last question, if you want to pursue it, you can specify the
row indices in a view as well.  Or you can specify a viewWindow min and max
value to constrain what is visible.

On Sat, Mar 5, 2016 at 5:54 AM, Petr  wrote:

> I need to combine ChartRangeFilter with BarChart. This is currently not
> supported, because CharRangeFilter works on continuous axis, while BarChart
> needs discrete x-axis.
> On x-axis I have equidistant data ( January 2010, February 2010...)
>
> My first step was to create data table with two  x-axis columns. The first
> column is continuous and the second one is string ("Jan 2010"). Then I do
> something like this:
>
> ChartRangeFilter.setView({'columns': [0,2]});
> BarChart.setView({'columns': [1,2]});
>
> That is - to ChartRangeFilter I set continuous axis and to  BarChart column
> with discrete axis.
> I see, that I can not bind the two chart by standard dashboard.bind, but I
> have to write my own hadler hoked on ChartRangeFilter statchange listener.
>
> My problem is, how to set data to BarChart in the linstener handler. I
> know, how to find start and end of the ChartRangeFilter, but how to fiter
> the data table and pass it to the BarChart?
>
> Thanks for any hint!
>
> --
> 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/06f85093-b078-41e9-8d0c-d8211d0a30e2%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com5CC, 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/CAOtcSJNpKZ%3DV64u-NeCYCGtOyZ0hPPHc-BnYjSLOe%3D-CKNEASg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] google charts scroll arrow size too large

['Daniel LaLiberte' via Google Visualization API]

Hi Domek,

There is a fix for this problem which you can see if you use the latest
version.
https://developers.google.com/chart/interactive/docs/release_notes#october-2-2015

On Sat, Mar 5, 2016 at 5:42 AM, Domek  wrote:

> According to the documentation, the legend scroll arrow size is fixed. I
> experienced a dependence on font size adjustments.
> Is there a workaround to adjust the scroll arrow size without making the
> label font size incredibly small?
>
> var options0 = {
>
>backgroundColor: "none",
>
> hAxis: {
>
> textPosition: 'none',
>
> gridlines: { count: -1},
>
> title: ''
>
> },
>
>'chartArea': {'width': 42*,
> 'height': optpercent, 'left':'235', 'top':'30' },
>
> 'legend': {position: 'right', textStyle: {color:
> '#00',fontName: 'Optima', fontSize:14}, pagingTextStyle: {color:
> '#5A', fontSize:14}, scrollArrows:{activeColor: '#5A',
> inactiveColor:'#D5E8E5'} },
>
>   title: ''
>
> };
>
> This leads to the following undesired result with huge scroll arrows. Are
> there any ideas to this problem? 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/c1d82628-3a96-46c5-b45b-fb69db1ff9a9%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com5CC, 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/CAOtcSJM_1iSEx7icRM7%3DKu%2B9TNfTnsrK0%3Dbq_AudLkgfiN9ggw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Problem plotting duration with google chart

['Daniel LaLiberte' via Google Visualization API]

Hi Hitesh,

The timeofday formatting doesn't currently know how to display values for
hours outside the normal range of a day since we use the standard Google
closure date/time formatting utilities that uses a subset of the ICU
formatting rules documented here:
http://userguide.icu-project.org/formatparse/datetime . Probably the
correct solution would be to add a formatting option to indicate you want
unbounded hours.  The same would apply to each of the other date/time
units: seconds, milliseconds, minutes, days and months.

In the meantime, you can include a day number in the format to at least
make the values be distinct and correct.

On Sat, Mar 5, 2016 at 2:32 AM, Hitesh Jain 
wrote:

> Hi
>
> I want to plot data on line chart where each rows corresponds to 1 month
> and columns contain duration.
>
> Following sheet contain sample data and plotted chart.
>
> https://docs.google.com/spreadsheets/d/1Dyf0wZ5m4SszDkXuey-0251wZXeXPYMnHFXOgZBjB8o/edit#gid=0
>
> I want to plot duration on Y axis such that it starts at 0:00 but in the
> chart it starts at 16:00 (I think it is doing so because duration more than
> 24:00 rolls up back to next day). I know this can be solved by making
> duration a decimal value (like 01:30 can be change to 1.5) but I want data
> to remain in format hh:mm for better readability. Moreover MS excel plots
> this correctly (I've attached an image in the document itself)
>
>
> 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/625cf1b3-44b6-47b2-9a9d-ca61a6f9cef6%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com5CC, 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/CAOtcSJMA5TFCnF-rQipaaS-PceS%3D-B3h5WFoT%2Brj4_QSxGUapA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: Google Charts with PHP and MySQL

['Daniel LaLiberte' via Google Visualization API]

Hi Krishna,

Your URL is the same as before, and results in an error.

On Mon, Mar 7, 2016 at 5:06 AM, Krishna Prasad  wrote:

>
> Now the URL changed as http://pinnacleinfotech.in/vivera/chart.html
> 
>
> On Tuesday, March 1, 2016 at 12:54:16 PM UTC+5:30, krishna prasad wrote:
>
>> Hi,
>>
>> My chart should exactly looks like this
>> http://onnetsourcing.com/vivera/chart.html . Here I have entered the
>> data in manual format. Please help me the script which istaking the data
>> from DB and display in the chart.html page. You can see the codes as below:
>>
>> https://www.google.com/jsapi";>
>> 
>> 
>> google.load("visualization", "1", {packages:["corechart"]});
>>
>> var dataSet = [
>> ['Date','1st Floor', '2nd Floor', '3rd Floor', '4th Floor', '5th Floor',
>> '6th Floor', '7th Floor', 'Tarrace Floor'],
>> ['A Block', 1, 1, 1, 0, 0, 0, 0, 0],
>> ['B Block', 1, 1, 1, 1, 1, 1, 1, 1],
>> ['C Block', 1, 1, 1, 1, 1, 1, 1, 1],
>> ['D Block', 1, 1, 1, 1, 1, 1, 1, 1],
>> ['E Block', 1, 1, 0, 0, 0, 0, 0, 0],
>> ['F Block', 1, 1, 0, 0, 0, 0, 0, 0],
>> ];
>>
>> // The first chart
>>
>> google.setOnLoadCallback(drawChart1);
>> function drawChart1() {
>> var data = google.visualization.arrayToDataTable( dataSet );
>>
>> var options = {
>> title: 'Project Progress Report\nTotals',
>> vAxis: {title: 'Completed Floors', maxValue: 8}, // sets the maximum value
>> backgroundColor: {strokeWidth: 2 }, // to draw a nice box all around the
>> chart
>> isStacked: 'true' // = rowstacked in gnuplot
>> };
>>
>> var chart = new
>> google.visualization.ColumnChart(document.getElementById('chart_div1'));
>> chart.draw(data, options);
>> }
>>
>> 
>>
>> 
>> 
>> 
>> ...
>
> --
> 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/98a0bd00-6f61-4426-9dcf-2085f746dea1%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Daniel LaLiberte 
dlalibe...@google.com5CC, 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/CAOtcSJPvPkJjjSaaMzX%2BONKB8UT3QKOQ7M1fAaM%2BNnSxibZWhA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [visualization-api] Re: Remove vertical axis

[natarajan govindavel]

it doesn't work on material chart.

On Tuesday, February 21, 2012 at 10:26:11 AM UTC+5:30, ChartMan wrote:
>
> Thanks for the screenshot.
>
> you can remove the baseline by using this option
> hAxis: {baselineColor: 'none'} 
>
> You would still see the underlying gridlines. To remove them you can set 
> their count to zero or the their color to 'none'
> hAxis: {baselineColor: 'none', gridlines: {color: 'none'}}
>
>
>
> On Tue, Feb 21, 2012 at 4:53 AM, Luiz > 
> wrote:
>
>> Hi ChartMan,
>>
>> I want to remove the line inside the red circle:
>>
>>
>> http://2.bp.blogspot.com/-7rG6S0ZUFiU/T0MHDeQv47I/AhM/jIGZDs8VyOw/s400/2.jpg
>>
>> Thanks.
>>
>> On Feb 20, 6:18 am, ChartMan  wrote:
>> > Remove in what sense?
>> > You can set its color to 'none' to hide it.
>> >
>> > HTH
>> > ChartMan
>> > On Feb 19, 2012 8:55 PM, "Luiz"  wrote:
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > > Hi,
>> >
>> > > How do I remove the vertical axis of a bar chart?
>> >
>> > > Thanks.
>> >
>> > > --
>> > > You received this message because you are subscribed to the Google 
>> Groups
>> > > "Google Visualization API" group.
>> > > To post to this group, send email to
>> > > google-visua...@googlegroups.com .
>> > > To unsubscribe from this group, send email to
>> > > google-visualization-api+unsubscr...@googlegroups.com .
>> > > For more options, visit this group at
>> > >http://groups.google.com/group/google-visualization-api?hl=en.
>>
>> --
>> You received this message because you are subscribed to the Google Groups 
>> "Google Visualization API" group.
>> To post to this group, send email to google-visua...@googlegroups.com 
>> .
>> To unsubscribe from this group, send email to 
>> google-visualization-api+unsubscr...@googlegroups.com .
>> For more options, visit this group at 
>> http://groups.google.com/group/google-visualization-api?hl=en.
>>
>>
>

-- 
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/fc9932c8-ce90-4e6a-9121-dd440a4c7d25%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]

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 govindavel wrote:
>
> Hi Sergey,
>
> Thank so much for your support. Almost fixed all the issues except one.
> Is their anyway to hiding these (highlighted) supplementary axis from the 
> chart.
>
>
> 
>
> Thanks
> Natarajan Govindavel
>
> On Wednesday, February 24, 2016 at 9:31:59 PM UTC+5:30, Sergey wrote:
>
> Hi Natarajan,
>
> You should be able to use html2canvas to save the charts as images, as the 
> stackoverflow post suggests. You may be aware that some of our charts (like 
> ComboChart and the rest of the charts provided by the 'corechart' package) 
> support getImageUri, which will basically allow you to save images of the 
> charts, but Material Charts do not yet support this API.
>
> On Wed, Feb 24, 2016 at 10:26 AM natarajan govindavel  
> wrote:
>
> Hi Sergey,
>
> Is there any other way to save material chart as images.
> like given in that link : 
> http://stackoverflow.com/questions/6887183/how-to-take-screen-shot-of-a-div-with-javascript
>
> Thanks
> Natarajan Govidavel
>
>
> On Friday, February 19, 2016 at 8:43:59 PM UTC+5:30, Sergey wrote:
>
> So I don't see anything obviously wrong with your code. Could you link to 
> a page on which you're experiencing the error? If you're uncomfortable 
> sharing the link over the forum, feel free to send me a private message.
>
> On Fri, Feb 19, 2016 at 8:47 AM natarajan govindavel  
> wrote:
>
> Hi sergey,
>
> I have seen  below mentioned issue in browser console
> Error: one or more fonts could not be loaded.
>
> In FireFox (44.0.2) this issue happen more frequently.
> And I checked with the link 
>
> https://groups.google.com/forum/#!topic/google-visualization-api/bSJLBO_fm2w
>
> so i changed from current to 43 still issue exists.
> And my code is very complex because making the array dynamically from 
> webservice (asmx) and calling that data using jquery ajax.
>
> function ChangePeriodL(id) {
> if (id != "") {
> $(".loc").removeClass('active');
> $(id).addClass('active');
> value = $(id).attr('id');
> event_id = "CLICK"; //click event
> g_var = 0;
> } else
> value = 0;
> $.ajax({
> type: "POST",
> url: "remote url",
> contentType: "application/json; charset=utf-8",
> dataType: "json",
> data: JSON.stringify({
> "timespan": value
> }),
> success: function(data) {
> if (data.d != "Empty") {
> addCode(data.d);
> if (typeof dataArray[8] != "undefined") {
> $('#AllLoc').text(TitleArray[8]);
> if (dataArray[8].getNumberOfRows() > 3)
> var height = dataArray[8].getNumberOfRows() * 40 + 
> 100; //Set dynamic height = Number of Rows * bar + padding
> else
> var height = 300;
>
> $('#div_id_9').height(height);
> var chartnew = new 
> google.charts.Bar(document.getElementById('div_id_9'));
> chartnew.draw(dataArray[8], 
> google.charts.Bar.convertOptions({
> width: 1000,
> height: '100%',
> titlePosition: 'none', //hiding chart title 
> legend: {
> position: 'right' //place chart legend at 
> right side 
> },
> isStacked: true, //for stacked chart
> vAxis: {
> title: "Incident Count",
> textStyle: {
> color: 'black'
> }
> },
> hAxis: {
> title: "Locations",
> textStyle: {
> color: 'black'
> }
> },
> bars: 'horizontal', //for showing bars horizontal
> series: {
> 0: {
> targetAxisIndex: 0,
> color: '#F3C1BC'
> },
> 1: {
> targetAxisIndex: 0,
> color: '#E7827A'
> },
> 2: {
> targetAxisIndex: 0,
> color: '#DB4437'
> }
> }
> }));
> google.visualization.events.addListener(chartnew, 
> 'ready', myReadyHandler);
> }
>   

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

[natarajan govindavel]

Hi Sergey,

I am using the Visualization (classical) and Material Chart on the same 
page.

As mention below.

   https://www.google.com/jsapi?autoload={
'modules':[{
  'name':'visualization',
  'version':'1.1',
  'packages':['corechart','bar','controls']
}]
  }">
  https://www.gstatic.com/charts/loader.js";>
  

[visualization-api] Re: I am getting an error "Cannot read property 'prototype' of null"

[Md Rehan Moazzam]

Thanks Sergey. I followed the same and its working fine. :)

On Wednesday, March 2, 2016 at 1:05:29 PM UTC+5:30, Md Rehan Moazzam wrote:
>
> I am getting an error "Cannot read property 'prototype' of null" whenever 
> I am trying to create a chart.
>
> The code follows:
>
> https://www.gstatic.com/charts/loader.js";>
>
>
> 
> // Load the Visualization API and the controls package.
> google.charts.load('current', { 'packages': ['controls'] });
>
> // Set a callback to run when the Google Visualization API is loaded.
> google.charts.setOnLoadCallback(drawDashboard);
>
> // Callback that creates and populates a data table,
> // instantiates a dashboard, a range slider and a pie chart,
> // passes in the data and draws it.
> function drawDashboard() {
>
> // Create our data table.
> var data = google.visualization.arrayToDataTable([
>   ['Name', 'Donuts eaten'],
>   ['Michael', 5],
>   ['Elisa', 7],
>   ['Robert', 3],
>   ['John', 2],
>   ['Jessica', 6],
>   ['Aaron', 1],
>   ['Margareth', 8]
> ]);
>
> // Create a dashboard.
> var dashboard = new google.visualization.Dashboard(
> document.getElementById('programmatic_dashboard_div'));
>
> // Create a range slider, passing some options
> var donutRangeSlider = new google.visualization.ControlWrapper({
> 'controlType': 'NumberRangeFilter',
> 'containerId': 'programmatic_control_div',
> 'options': {
> 'filterColumnLabel': 'Donuts eaten'
> }
> });
>
> // Create a pie chart, passing some options
> var pieChart = new google.visualization.ChartWrapper({
> 'chartType': 'PieChart',
> 'containerId': 'programmatic_chart_div',
> 'options': {
> 'width': 300,
> 'height': 300,
> 'pieSliceText': 'value',
> 'legend': 'right'
> }
> });
>
> // Establish dependencies, declaring that 'filter' drives 
> 'pieChart',
> // so that the pie chart will only display entries that are let 
> through
> // given the chosen slider range.
> dashboard.bind(donutRangeSlider, pieChart);
>
> // Draw the dashboard.
> dashboard.draw(data);
> }
> 
>   
> 
>   
> 
>   
> 
>   
>
> 
>   
>   
>   
>   
>   
>   
> 
>   
>
>
>
>
> Error screen from chrome console is attached. Please help me out its kind 
> of urgent
>
>

-- 
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/dbec10cf-1a35-462e-b9f1-5df724c861c0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[visualization-api] Data Format from External Source to Googe chart

[Md Rehan Moazzam]

Hi,

I am using C# webmethod  to provide data to Google line chart. However I am 
stuck with the format of the data.

Currently I can only send data in "List" format. But I want to send 
data in DataTable format.

Is this possible?

Please find my code snippet below:

ASP Page

//call to get data from ASP web method

$.ajax({
type: "POST",
contentType: 'application/json',
data: '{}',
url: 'AdminDashboard.aspx/GetChartData',
beforeSend: function () { alert("before send"); },
complete: function () { alert("complete"); },
success: function (data) {

var linedata1 = new 
google.visualization.arrayToDataTable(data.d);

linedata1.insertColumn(0, 'date', 
linedata1.getColumnLabel(0));
// copy values from column 1 (old column 0) to column 0, 
converted to Date
for (var i = 0; i < linedata1.getNumberOfRows() ; i++) {
var val = linedata1.getValue(i, 1);
if (val != '' && val != null) {
var dateArray = val.split('/');
var year = dateArray[2];
var month = dateArray[0] - 1; // convert to 
javascript's 0-indexed months
var day = dateArray[1];
linedata1.setValue(i, 0, new Date(year, month, 
day));
}
}
// remove column 1 (the old column 0)
linedata1.removeColumn(1);

   

dashboard.bind(programmaticSlider, programmaticChart);
dashboard.draw(linedata1);
}



ASP webmethod

[WebMethod]
public static List GetChartData()
{
DataTable chartData = new DataTable();
DataTable tktData = new DataTable();
Array arrdata=null;
SPList configList, tktList;
SPQuery dataQuery;
SPListItemCollection configColl;


SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite oSite = new SPSite("http://dsknomoe11:9696/";))
{
using (SPWeb oWeb = oSite.OpenWeb())
{
//Get Config list value for Ticket Priority and 
Ticket Status
configList = 
oWeb.Lists.TryGetList("SCMS_Configuration");
dataQuery = new SPQuery();
dataQuery.Query = "Ticket PriorityTicket Status";
configColl = configList.GetItems(dataQuery);

//Ticket Priority and status
foreach(SPListItem oItem in configColl)
{
//Get Ticket Priority
if (oItem["Title"].ToString().Equals("Ticket 
Priority"))
{
tktPriority = 
oItem["value"].ToString().Split(';');
}
//Get Ticket Status
else if 
(oItem["Title"].ToString().Equals("Ticket Status"))
{
tktStatus = 
oItem["value"].ToString().Split(';');
}
}

//Add columns to DataTable ChartData
foreach (string s in tktStatus)
{
chartData.Columns.Add(s);
}

//Get Config list value for Ticket Priority and 
Ticket Status
tktList = oWeb.Lists.TryGetList("SCMS_Tickets");
dataQuery = new SPQuery();
dataQuery.Query = "Yes";

dataQuery.ViewFields = "";
dataQuery.ViewFieldsOnly = true;
tktData = 
tktList.GetItems(dataQuery).GetDataTable();

var grpdata= tktData.AsEnumerable().Select(x => new 
{ Date = Convert.ToDateTime(x[0]).Date.ToString("MM/dd/"), Status = 
x[2] }).ToArray();

arrdata = grpdata.GroupBy(l => l.Date).Select(g => 
new
{
Date = g.Key,
Open = g.Count(l => (string)l.Status == "Open"),
Closed = g.Count(l => (string)l.Status == 
"Closed"),
InProgress = g.Count(l => (string)l.Status == 
"In-Progress"),
Total = g.Count(l => ((string)l.Status == 
"Open") || ((string)l.Status == "Closed") || ((string)l.Status == 
"In-Progress"))
}).ToArray();

}
}
});


List list = new List();
list.Add(new object[] 
{"Date","Open","Closed","In-Progr

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

[natarajan govindavel]

Hi Sergey,

Thank so much for your support. Almost fixed all the issues except one.
Is their anyway to hiding these (highlighted) supplementary axis from the 
chart.



Thanks
Natarajan Govindavel

On Wednesday, February 24, 2016 at 9:31:59 PM UTC+5:30, Sergey wrote:
>
> Hi Natarajan,
>
> You should be able to use html2canvas to save the charts as images, as the 
> stackoverflow post suggests. You may be aware that some of our charts (like 
> ComboChart and the rest of the charts provided by the 'corechart' package) 
> support getImageUri, which will basically allow you to save images of the 
> charts, but Material Charts do not yet support this API.
>
> On Wed, Feb 24, 2016 at 10:26 AM natarajan govindavel  > wrote:
>
> Hi Sergey,
>
> Is there any other way to save material chart as images.
> like given in that link : 
> http://stackoverflow.com/questions/6887183/how-to-take-screen-shot-of-a-div-with-javascript
>
> Thanks
> Natarajan Govidavel
>
>
> On Friday, February 19, 2016 at 8:43:59 PM UTC+5:30, Sergey wrote:
>
> So I don't see anything obviously wrong with your code. Could you link to 
> a page on which you're experiencing the error? If you're uncomfortable 
> sharing the link over the forum, feel free to send me a private message.
>
> On Fri, Feb 19, 2016 at 8:47 AM natarajan govindavel  
> wrote:
>
> Hi sergey,
>
> I have seen  below mentioned issue in browser console
> Error: one or more fonts could not be loaded.
>
> In FireFox (44.0.2) this issue happen more frequently.
> And I checked with the link 
>
> https://groups.google.com/forum/#!topic/google-visualization-api/bSJLBO_fm2w
>
> so i changed from current to 43 still issue exists.
> And my code is very complex because making the array dynamically from 
> webservice (asmx) and calling that data using jquery ajax.
>
> function ChangePeriodL(id) {
> if (id != "") {
> $(".loc").removeClass('active');
> $(id).addClass('active');
> value = $(id).attr('id');
> event_id = "CLICK"; //click event
> g_var = 0;
> } else
> value = 0;
> $.ajax({
> type: "POST",
> url: "remote url",
> contentType: "application/json; charset=utf-8",
> dataType: "json",
> data: JSON.stringify({
> "timespan": value
> }),
> success: function(data) {
> if (data.d != "Empty") {
> addCode(data.d);
> if (typeof dataArray[8] != "undefined") {
> $('#AllLoc').text(TitleArray[8]);
> if (dataArray[8].getNumberOfRows() > 3)
> var height = dataArray[8].getNumberOfRows() * 40 + 
> 100; //Set dynamic height = Number of Rows * bar + padding
> else
> var height = 300;
>
> $('#div_id_9').height(height);
> var chartnew = new 
> google.charts.Bar(document.getElementById('div_id_9'));
> chartnew.draw(dataArray[8], 
> google.charts.Bar.convertOptions({
> width: 1000,
> height: '100%',
> titlePosition: 'none', //hiding chart title 
> legend: {
> position: 'right' //place chart legend at 
> right side 
> },
> isStacked: true, //for stacked chart
> vAxis: {
> title: "Incident Count",
> textStyle: {
> color: 'black'
> }
> },
> hAxis: {
> title: "Locations",
> textStyle: {
> color: 'black'
> }
> },
> bars: 'horizontal', //for showing bars horizontal
> series: {
> 0: {
> targetAxisIndex: 0,
> color: '#F3C1BC'
> },
> 1: {
> targetAxisIndex: 0,
> color: '#E7827A'
> },
> 2: {
> targetAxisIndex: 0,
> color: '#DB4437'
> }
> }
> }));
> google.visualization.events.addListener(chartnew, 
> 'ready', myReadyHandler);
> }
> } else {
> $('#AllLoc').text("All Incident By Location");
> $("#div_id_9").html(message);
> myReadyHandler(); // increment th

[visualization-api] Re: Google Charts with PHP and MySQL

[Krishna Prasad]

Now the URL changed as http://pinnacleinfotech.in/vivera/chart.html 


On Tuesday, March 1, 2016 at 12:54:16 PM UTC+5:30, krishna prasad wrote:
>
> Hi,
>
> My chart should exactly looks like this 
> http://onnetsourcing.com/vivera/chart.html . Here I have entered the data 
> in manual format. Please help me the script which istaking the data from DB 
> and display in the chart.html page. You can see the codes as below:
>
> https://www.google.com/jsapi";>
> 
> 
> google.load("visualization", "1", {packages:["corechart"]});
>
> var dataSet = [
> ['Date','1st Floor', '2nd Floor', '3rd Floor', '4th Floor', '5th Floor', 
> '6th Floor', '7th Floor', 'Tarrace Floor'],
> ['A Block', 1, 1, 1, 0, 0, 0, 0, 0],
> ['B Block', 1, 1, 1, 1, 1, 1, 1, 1],
> ['C Block', 1, 1, 1, 1, 1, 1, 1, 1],
> ['D Block', 1, 1, 1, 1, 1, 1, 1, 1],
> ['E Block', 1, 1, 0, 0, 0, 0, 0, 0],
> ['F Block', 1, 1, 0, 0, 0, 0, 0, 0],
> ];
>
> // The first chart
>
> google.setOnLoadCallback(drawChart1);
> function drawChart1() {
> var data = google.visualization.arrayToDataTable( dataSet );
>
> var options = {
> title: 'Project Progress Report\nTotals',
> vAxis: {title: 'Completed Floors', maxValue: 8}, // sets the maximum value
> backgroundColor: {strokeWidth: 2 }, // to draw a nice box all around the 
> chart
> isStacked: 'true' // = rowstacked in gnuplot
> };
>
> var chart = new 
> google.visualization.ColumnChart(document.getElementById('chart_div1'));
> chart.draw(data, options);
> }
>
> 
>
> 
> 
> 
> ...

-- 
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/98a0bd00-6f61-4426-9dcf-2085f746dea1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.