[visualization-api] Re: Export Google Chart in Excel using Javascript ASP.NetC#
Thanks Andrew, I need to export using code without any manual activity. On Friday, September 5, 2014 7:43:21 AM UTC+5:30, Andrew Gallant wrote: You have to save the image/octet stream as a .png file and then import the file into Excel. To save the stream as a file, set the src of an img tag to the URI, then right-click on the generated image and click save as. On Thursday, September 4, 2014 5:09:31 AM UTC-4, Gaurav Mishra wrote: Hi All, I am using Google Chart in a web Application. I want to export Google Chart in Excel. Google Chart Provides Image Data as *data:image/png* followed by coded string (“*data:image/png;base64,iVBO…*” ). It is easily rendered in HTML and PDF(using JsPDF ) but not working in excel export using html. Please Assist 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. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Multiple rows in one tooltip
I have a bar with several boxes. But what I want is a bar without the boxes, just the bar, with only one tooltip which contains all the activities of my training session. Like this : https://lh5.googleusercontent.com/-pp5MfjDVdy4/VAlrsCF_cTI/ACI/PzWFlDYn35k/s1600/HELP.png Just one blue block for my individual training session, but all the activities of the individual training session visible in the tooltip. -- 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. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Color for Timeline Chart with 3 categories
Thanks for remember this, Andrew. Gonna give a try. On Thursday, September 4, 2014 11:00:10 PM UTC-3, Andrew Gallant wrote: In case you are still looking for a solution, I found a way to do this that actually works properly using the style column role to color the bars without having to go through the process of building the array of colors: http://jsfiddle.net/asgallant/axr7h/8/ On Tuesday, May 20, 2014 8:12:48 PM UTC-4, Khrys wrote: Thanks again Andrew. Maybe if someone from google viz could give us some more detail on this. With your help I can see it is not trustable to use this chart the way I was expecting. First it is not possible to set the height in %, now this situation with the colors, : ( Thanks again for your time. On Tuesday, May 20, 2014 6:29:06 PM UTC-3, Andrew Gallant wrote: The Timeline might be sorting the data by start date before assigning colors. When I applied a sort to the DataTable, it looks more correct, but I don't think it's quite right still: http://jsfiddle.net/asgallant/axr7h/6/. If you change the column used to sort, you can clearly see the effect it has on the chart. The documentation on the Timeline is quite ambiguous as to how the colors are actually applied (it says they are applied to bars in order, but how the bars are ordered is left out). On Tuesday, May 20, 2014 4:14:31 PM UTC-4, Khrys wrote: Andrew helps me set colors for category in timeline chart (thanks again o/). I was testing and found a weird behavior. For example, the itens starting with T should always be black because all have the CategoryA, but this isn't happening: http://jsfiddle.net/Khrys/axr7h/5/ Thanks for the help. -- 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. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: GeoChart and Strings problem !!
Hi, this is bad.. and how should i reactif no data point is available what should i return back that i become no error? or what is the best method to delete the Map chart ? the clearChart function did not work there! Am Donnerstag, 4. September 2014 00:59:17 UTC+2 schrieb Andrew Gallant: Ahh, I see. The Map visualization expects at least one data point, and there is no way to override that behavior. On Monday, September 1, 2014 12:00:49 PM UTC-4, cyb wrote: Hi, ok i have created a simple example in jsfiddle and there is the same error(i use chrome as browser): This error appears only if the rows[] array is empty for example if the getFilteredRows() method finds nothing.. http://jsfiddle.net/cyb2k/z8s8t1tb/10/ you must open the console and wait maybe a few seconds then the error in my picture above appears. If you click with the mouse on the chart it produces more errors.. Am Montag, 1. September 2014 16:19:23 UTC+2 schrieb Andrew Gallant: Can you create a simplified example that demonstrate this behavior so I can test it? On Sunday, August 31, 2014 5:36:38 PM UTC-4, cyb wrote: Hi, ok i have found another problem.. i use the Map Chart with a chartWrapper and i build a filtered view like this(I use the latitude longitude mode): var filteredView ={columns : [0,1,2], rows : dataTable.getFilteredRows([{column: 2, minValue: 100, maxValue: null}])}; so for example the minValue is 100, but 100 did not exists in the DataTable. This is no problem by other charts but if the dataTable.getFilteredRows() method did not find any results and i give this view to my chartWrapper it throws an ugly error message. It looks like this: https://lh5.googleusercontent.com/-c1ksluWoPu4/VAOUHMfNZnI/AAM/4wUY_iPR-eI/s1600/GeoMAPerror.PNG How can i solve this problem if my filter did not find a result ? Can i display an empty chart or an chart with no markers ? and the problem that chartWrapper.getChart().clearChart(); is not working with a Map Chart, still exists... Am Sonntag, 31. August 2014 00:52:53 UTC+2 schrieb cyb: Hi, ok i have fixed the problem, i did transform Column 3 in a String and add a tooltip directliy in my view like this: var toolTip=[ { type: 'string', role: 'tooltip', calc: function(dt,row){ return 'Column:'+dt.getColumnLabel(3); } } ]; the only problem is now, that the markers are to big, can i adjust the size of all markers in the options ? i need only one size for all markers! and i have a second Question.. i have tried the Geo MAP, there is the same problem with Strings, but my custom tooltip above did not work there! is it possible to add custom tooltips to the Geo MAP(google maps) !? and i use a chartwrapper... normally i clear my chart with chartWrapper.getChart().clearChart(); but this did not work with google maps, is there something similar to clear the chart if i use google maps !? Am Freitag, 29. August 2014 23:57:24 UTC+2 schrieb cyb: Hi, i want implement a GeoChart https://developers.google.com/chart/interactive/docs/gallery/geochart?hl=de i have a DataTable with some Date Values but it seems that a GeoChart can not handle Date values, is this true ? then i have tried to stringify my Date Values, this works but then the tooltips did only show the value! if you go to this page https://developers.google.com/chart/interactive/docs/gallery/geochart?hl=de and open the first jsfiddle link. The Tooltip shows for Canada: Canada Popularity: 500 this is correct, but if i replace the numbers with strings like this: var data = google.visualization.arrayToDataTable([ ['Country', 'Popularity'], ['Germany', 'A'], ['United States', 'B'], ['Brazil', 'C'], ['Canada', 'D'], ['France', 'E'], ['RU', 'F'] ]); it shows only D but i want this: Canada Popularity: D how can i fix this !? The same problem is with the latitude and longitude mode! i use a DataWrapper and i build my own view, i do the stringify like this: var latLongView=[0,1]; var xyViewStringify = [ { sourceColumn: 2, type: 'string', calc: 'stringify' } ]; //--- latLongView.push.apply(latLongView, xyViewStringify); this works but the problem is the wrong tooltip!! -- 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
[visualization-api] Problem with minValue and maxValue for vAxes in combo chart
Hello, I have a problem with the min value of the vAxes in my combo chart. Actually I have this : https://lh5.googleusercontent.com/-ndoEr5TD4Yk/VAm2cHujKfI/ACY/OuEawwbSQT8/s1600/HELP.png The red line is at -15 but the min value of my vAxes are -150 and -50. I tried to change this value with the minValue parameter, but it doesn't work. Have you an idea please? Thanks, Alexandre. -- 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. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Stack columns. Issues with custom tooltip.
First, thx for all your answers and your advice for createTooltip function :) The data I get from the API is not formatted as Google Charts expect but I found a way to do it nicely :p -- 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. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Stack columns. Issues with custom tooltip.
I copied your anwser on Stackoverflow http://stackoverflow.com/questions/25625033/google-visualization-stack-columns-issues-with-html-custom-tooltips/25687093#25687093 Hope your are ok with it :p -- 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. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Problem with minValue and maxValue for vAxes in combo chart
It appears your chart is doing what you described, so it is not clear what you want it to do that is different from that. I assume the red line is using the right-side axis and the bars are using the left-side axis. On Fri, Sep 5, 2014 at 9:13 AM, Alexandre Carrie alexandre.car...@ipa-consulting.fr wrote: Hello, I have a problem with the min value of the vAxes in my combo chart. Actually I have this : https://lh5.googleusercontent.com/-ndoEr5TD4Yk/VAm2cHujKfI/ACY/OuEawwbSQT8/s1600/HELP.png The red line is at -15 but the min value of my vAxes are -150 and -50. I tried to change this value with the minValue parameter, but it doesn't work. Have you an idea please? Thanks, Alexandre. -- 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. For more options, visit https://groups.google.com/d/optout. -- Daniel LaLiberte https://plus.google.com/100631381223468223275?prsrc=2 - 978-394-1058 dlalibe...@google.com dlalibe...@google.com 5CC, Cambridge MA daniel.lalibe...@gmail.com 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. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Problem with minValue and maxValue for vAxes in combo chart
I just want to put the minValue of the two vAxis to -15. I don't want -50 and -150. -- 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. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Problem with minValue and maxValue for vAxes in combo chart
The minValue option is probably not doing what you assumed. It only specifies a value that is effectively added to your data, so the chart ensures that the minValue appears in the chart, but it doesn't mean the axis will go no lower than the minValue. However, the viewWindow.min option will do what you want. vAxis: { viewWindow: { min: -15 } } On Fri, Sep 5, 2014 at 10:31 AM, Alexandre Carrie alexandre.car...@ipa-consulting.fr wrote: I just want to put the minValue of the two vAxis to -15. I don't want -50 and -150. -- 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. For more options, visit https://groups.google.com/d/optout. -- Daniel LaLiberte https://plus.google.com/100631381223468223275?prsrc=2 - 978-394-1058 dlalibe...@google.com dlalibe...@google.com 5CC, Cambridge MA daniel.lalibe...@gmail.com 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. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Problem with minValue and maxValue for vAxes in combo chart
You will have to specify the same viewWindow for *both* of your vAxes that should have the same viewWindow. Or you could *add* another option which is just the vAxis (rather than vAxes) as I said before. On Fri, Sep 5, 2014 at 11:05 AM, Alexandre Carrie alexandre.car...@ipa-consulting.fr wrote: You can see the result : https://lh3.googleusercontent.com/-IwXDHm-CzMg/VAnQxFrtNQI/ACo/8GeKmkcPXUM/s1600/HELP.png And my code : https://lh5.googleusercontent.com/-7bDNJerH5Ho/VAnQ2omROzI/ACw/U42Sfp7teJ0/s1600/HELP2.PNG I have tried the viewWindowsMode option too. -- 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. For more options, visit https://groups.google.com/d/optout. -- Daniel LaLiberte https://plus.google.com/100631381223468223275?prsrc=2 - 978-394-1058 dlalibe...@google.com dlalibe...@google.com 5CC, Cambridge MA daniel.lalibe...@gmail.com 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. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Problem with minValue and maxValue for vAxes in combo chart
You can see the result : https://lh3.googleusercontent.com/-IwXDHm-CzMg/VAnQxFrtNQI/ACo/8GeKmkcPXUM/s1600/HELP.png And my code : https://lh5.googleusercontent.com/-7bDNJerH5Ho/VAnQ2omROzI/ACw/U42Sfp7teJ0/s1600/HELP2.PNG I have tried the viewWindowsMode option too. -- 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. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Problem with minValue and maxValue for vAxes in combo chart
Result when I put the viewWindow option for both of my vAxes : https://lh5.googleusercontent.com/-myV1ymmxvB4/VAnVIQnuBmI/AC8/GThbDKbhV10/s1600/HELP.png And when I add another option it doesn't work. -- 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. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Problem with minValue and maxValue for vAxes in combo chart
If you add the vAxis.viewWindow.min option, you would have to remove the viewWindow.min option from each of the vAxes, otherwise they override. So now it appears that in the chart you attached, the lowest axis values are be the same value of -15 in both axes. However, now you probably want to deal with the misaligned sets of ticks/gridlines for both the left and right axes. Since you are using different scales for each, you'll have to figure out how you want them to align and control the range and number of gridlines so it works out the way you want. There is no feature currently to say, for example, align the 0 values of both axes. But it sounds like you want -15 to be aligned rather than 0, since you want -15 on the bottom of both axes. If so, then your 0s won't be aligned. If you say which way you want it, I can then offer more suggestions about how to achieve that. One option that might help make all this simpler is the explicit 'ticks' option, which lets you specify exactly what tick values you want to see in an axis. But specifying the tick values still doesn't say which tick value is aligned in both axes. On Fri, Sep 5, 2014 at 11:31 AM, Alexandre Carrie alexandre.car...@ipa-consulting.fr wrote: Result when I put the viewWindow option for both of my vAxes : https://lh5.googleusercontent.com/-myV1ymmxvB4/VAnVIQnuBmI/AC8/GThbDKbhV10/s1600/HELP.png And when I add another option it doesn't work. -- 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. For more options, visit https://groups.google.com/d/optout. -- Daniel LaLiberte https://plus.google.com/100631381223468223275?prsrc=2 - 978-394-1058 dlalibe...@google.com dlalibe...@google.com 5CC, Cambridge MA daniel.lalibe...@gmail.com 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. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Export Google Chart in Excel using Javascript ASP.NetC#
You could use javascript to fetch the URI and send it to your server via AJAX, then have the server convert it to a .png file. On Friday, September 5, 2014 2:09:07 AM UTC-4, Gaurav Mishra wrote: Thanks Andrew, I need to export using code without any manual activity. On Friday, September 5, 2014 7:43:21 AM UTC+5:30, Andrew Gallant wrote: You have to save the image/octet stream as a .png file and then import the file into Excel. To save the stream as a file, set the src of an img tag to the URI, then right-click on the generated image and click save as. On Thursday, September 4, 2014 5:09:31 AM UTC-4, Gaurav Mishra wrote: Hi All, I am using Google Chart in a web Application. I want to export Google Chart in Excel. Google Chart Provides Image Data as *data:image/png* followed by coded string (“*data:image/png;base64,iVBO…*” ). It is easily rendered in HTML and PDF(using JsPDF ) but not working in excel export using html. Please Assist 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. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Multiple rows in one tooltip
Ahh, I see. You can do this with a single data series with a custom tooltip that contains the information you want: var data = google.visualization.arrayToDataTable([ ['Date', 'Value', {role: 'tooltip', type: 'string', p: {html: true}}], [new Date(2014, 7, 28), 305, 'divSeance individuelle 1 - Musculation du haut: b40/bbr/Seance individuelle 1: b225/bbr/Seance individuelle 1 - Musculation du bas: b40/b/div'] ]); In the chart options, you have to set the tooltip.isHtml option to true. On Friday, September 5, 2014 3:56:19 AM UTC-4, Alexandre Carrie wrote: I have a bar with several boxes. But what I want is a bar without the boxes, just the bar, with only one tooltip which contains all the activities of my training session. Like this : https://lh5.googleusercontent.com/-pp5MfjDVdy4/VAlrsCF_cTI/ACI/PzWFlDYn35k/s1600/HELP.png Just one blue block for my individual training session, but all the activities of the individual training session visible in the tooltip. -- 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. For more options, visit https://groups.google.com/d/optout.