[visualization-api] Re: Customizing hAxis and not showing all values

2014-09-16 Thread Andrew Gallant
What does your DataTable look like? Specifically, is your first column type string or datetime? On Monday, September 15, 2014 10:57:30 PM UTC-4, Ronneil Camara wrote: Hi folks, I have a 24 hr data points and each point has a date and an hour. I would like to only show few dates at the hAxis

[visualization-api] Re: Annotation Charts-Setting range of Chart range filter

2014-09-16 Thread Andrew Gallant
google.visualization.DataTable(jsondata); } On Tuesday, September 16, 2014 4:54:52 AM UTC+5:30, Andrew Gallant wrote: I believe you want to set the chart range after redrawing. Try using a ready event handler to do this: function Callback(result) { data = new google.visualization.DataTable(result

[visualization-api] Re: Problem with displaying a chart after Button-Click

2014-09-16 Thread Andrew Gallant
Load the API first, then assign the chart drawing function to a handler for the button click: function drawChart () { // create and draw the chart } function init () { // create click event handler for button that calls drawChart } google.load('visualization', '1',

[visualization-api] Re: Customizing hAxis and not showing all values

2014-09-16 Thread Andrew Gallant
You can use the hAxis.ticks option to specify which values you want labels at: hAxis: { ticks: [new Date(2014, 8, 15, 0), new Date(2014, 8, 15, 6), new Date(2014, 8, 15, 12), new Date(2014, 8, 15, 18)] } This will place labels at 12am, 6am, 12pm, and 6pm on September 15. On Tuesday,

[visualization-api] Re: HTML tooltips for the Org Chart?

2014-09-16 Thread Andrew Gallant
No, HTML tooltips are not supported on the OrgCharts, sorry. On Tuesday, September 16, 2014 12:39:17 PM UTC-4, Jonathan Glass wrote: Can it be done? I have had no luck. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To

[visualization-api] Re: Line Chart for several days

2014-09-15 Thread Andrew Gallant
no longer displayed correctly. How can I rotate the lable? The vertical X-axis grid will no longer be displayed. Can I show this? Thanks Am Sonntag, 14. September 2014 14:44:24 UTC+2 schrieb Andrew Gallant: Oh, I see now. Your first data set was close to what you want, you need to add

[visualization-api] Re: Annotation Charts-Setting range of Chart range filter

2014-09-15 Thread Andrew Gallant
I believe you want to set the chart range after redrawing. Try using a ready event handler to do this: function Callback(result) { data = new google.visualization.DataTable(result); var range = data.getColumnRange(0); google.visualization.events.addOneTimeListener(chart, 'ready',

[visualization-api] Re: Column Charts spacing

2014-09-15 Thread Andrew Gallant
That link does not show anything, but I believe I know how to fix your problem anyway. Set the chartArea.top/left/width/height options to change the location and dimensions of the inner chart area (where the bars are drawn): chartArea: { top: 10, left: '5%', height: 350,

[visualization-api] Re: Set a Gridline font, color, value, and width

2014-09-15 Thread Andrew Gallant
You can do something similar with domain-axis annotations, which allow you to create labelled vertical lines on your chart. They are not customizable to the extent that you are looking for, though (you can color them, but they will all have the same color; you cannot change the line width).

[visualization-api] Re: Line Chart for several days

2014-09-14 Thread Andrew Gallant
... 12.00 ... 18.00 Is that possible? Thanks Am Samstag, 13. September 2014 18:45:46 UTC+2 schrieb Andrew Gallant: If you don't need the date for anything, you could switch your first column to a timeofday data type, which would align all of your data on a single span of hours

[visualization-api] Re: Line Chart for several days

2014-09-13 Thread Andrew Gallant
the data in the Datatable-Aarray so I can indicate the data as shown in the picture? Is that even possible with the Google Chart. Thanks Am Samstag, 13. September 2014 00:48:13 UTC+2 schrieb Andrew Gallant: I don't understand what it is you would like to do. How does your example image

[visualization-api] Re: Dual Vertical axis both on left side of chart // tick text line break

2014-09-12 Thread Andrew Gallant
Sorry, but second and subsequent axes will always appear on the right. You can add a line break character (\n) to the text to force a line break, which should work for axis labels, though it may not work in tooltips (and definitely won't work with HTML tooltips, where you would need a br/ tag

[visualization-api] Re: set width and height of chart but dynamically

2014-09-12 Thread Andrew Gallant
The chart will default to the size of its container, so the solution here is to put your container div inside another div with appropriate styling to make the container div the correct size. On Thursday, September 11, 2014 3:16:31 PM UTC-4, Ronneil Camara wrote: My chart is on a div and I

[visualization-api] Re: Line Chart for several days

2014-09-12 Thread Andrew Gallant
I don't understand what it is you would like to do. How does your example image relate to your data? What do you mean by only 1 curve instead of 5 (your data as-is should produce a LineChart with 4 lines)? On Friday, September 12, 2014 9:04:31 AM UTC-4, Schabagh wrote: Hi, how can I

Re: [visualization-api] Basic question about visualization chart

2014-09-12 Thread Andrew Gallant
There are a number of different ways of populating the data for a chart, most involve something similar to querying a database on your server, building a JSON representation of a DataTable from the query results, and serving that up to your charts. The specifics of how you do this depend

[visualization-api] Re: Same width for each bar

2014-09-10 Thread Andrew Gallant
tooltip-Window in Case2 only the days. I think I have also a problem with the indicate of chart under IE (10). As you see my chart has no gridline at the point 3000 (second post). Sometimes several gridlines are missing . Thanks Am Dienstag, 9. September 2014 14:51:56 UTC+2 schrieb Andrew

Re: [visualization-api] Display chart via function

2014-09-10 Thread Andrew Gallant
The reason it doesn't work has to do with some quirky behavior of the google loader. If you had used an inline callback, it would have worked, eg; function dspChart() { google.load('visualization', '1', {'packages':['corechart'], callback: drawChart}); } But I don't recommend calling

[visualization-api] Re: Help! on Annotation Chart creation from Mysql DB and PHP page

2014-09-10 Thread Andrew Gallant
The problem is because your index file has a .html extension; it should be .php: index.php. Your web server will not parse HTML files for PHP code; it just serves them up as-is. On Tuesday, September 9, 2014 3:54:03 AM UTC-4, Kasper Derkinderen wrote: Hi everyone, Yesterday I played around

[visualization-api] Re: Same width for each bar

2014-09-09 Thread Andrew Gallant
If you post some sample code I can use to replicate the chart, I will see what I can do to figure out what you need to change. On Tuesday, September 9, 2014 8:10:11 AM UTC-4, Schabagh wrote: Hi, I have solved the problem with the Day of Date. I have saved the day instead of whole date in

Re: [visualization-api] Re: Display total at top of legend in pie chart

2014-09-09 Thread Andrew Gallant
? Thanks, Manish On Mon, Aug 25, 2014 at 6:19 PM, Andrew Gallant agal...@google.com javascript: wrote: The charts do not have a loading message. You could change your loading code to turn off the loading image in the chart's ready event handler instead of turning it off when the data

[visualization-api] Re: Unable to set DateRangeFilter to today or yesterday

2014-09-08 Thread Andrew Gallant
with the settings: the first is the offset for the time zone, which is at least understandable, and the second is the way the call to slider.draw alters the selected date-times. - Bob On Saturday, September 6, 2014 6:53:55 PM UTC-4, Andrew Gallant wrote: Can you provide an example I can test

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

2014-09-08 Thread Andrew Gallant
I think your best bet is to use a DataView to calculate this for you: var view = new google.visualization.DataView(data); view.setColumns([0, { type: 'number', label: 'whatever you want to call this', calc: function (dt, row) { var sum = 0; for (var i = 1; i

[visualization-api] Re: Stacked Bar Chart Gaps between adjacent bars

2014-09-08 Thread Andrew Gallant
Sorry, but the API does not expose any options to change the bar separator. On Monday, September 8, 2014 7:28:57 PM UTC-4, Gene Kim wrote: I can't figure out how to remove the gaps or border between the stacked bars when using the Stacked Bar Chart. Image included with red boxes around the

[visualization-api] Re: Unable to set DateRangeFilter to today or yesterday

2014-09-08 Thread Andrew Gallant
of midnight because of daylight saving time? If I could tell it to ignore DST and I only fed it only midnights, it would work as needed. - Bob On Monday, September 8, 2014 9:05:51 PM UTC-4, Andrew Gallant wrote: After some experimentation, I have determined that the date range filter

[visualization-api] Re: GeoChart and Strings problem !!

2014-09-06 Thread Andrew Gallant
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

[visualization-api] Re: Problem showing table

2014-09-06 Thread Andrew Gallant
You need to add /gviz/tq to the end of the spreadsheet URL: http://jsfiddle.net/asgallant/jgfnyxzf/ On Saturday, September 6, 2014 3:15:04 AM UTC-4, Arno Koopmans wrote: Hi there, I am experimenting with the visualization api and cannot get my example working. What is going wrong? It

[visualization-api] Re: How to use decimal value in pie chart using google.visualization.DataTable()

2014-09-06 Thread Andrew Gallant
/div /body /html On Saturday, May 31, 2014 7:23:12 PM UTC-4, Andrew Gallant wrote: Can you share a complete example that demonstrates the problem? I have never seen decimal values cause a chart to fail to draw. On Saturday, May 31, 2014 3:18:16 AM UTC-4, Vikas Sangal

[visualization-api] Re: Unable to set DateRangeFilter to today or yesterday

2014-09-06 Thread Andrew Gallant
Can you provide an example I can test that demonstrates this effect? On Saturday, September 6, 2014 11:03:57 AM UTC-4, Bob Alexander wrote: Hi, I'm building a dashboard with a DateRangeFilter in it. I also have two buttons, labeled Today and Yesterday that set the range of the

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

2014-09-05 Thread Andrew Gallant
, 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

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

2014-09-05 Thread Andrew Gallant
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

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

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

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

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

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

2014-09-04 Thread Andrew Gallant
, : ( 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

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

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

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

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

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

2014-09-04 Thread Andrew Gallant
For the multiples bloc on the right. I would like to have just one bloc but with the same list in the tooltip. Is it possible? Le jeudi 4 septembre 2014 01:04:24 UTC+2, Andrew Gallant a écrit : Try setting the focusTarget option to category. This will add all of your data points

[visualization-api] Re: GeoChart and Strings problem !!

2014-09-03 Thread Andrew Gallant
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

[visualization-api] Re: Problem about PHP - parse a csv file and write output to another csv file with Google Charts

2014-09-03 Thread Andrew Gallant
Does your PHP code create the CSV correctly? On Tuesday, September 2, 2014 4:07:29 AM UTC-4, Kate tak wrote: I have some question about Problem about PHP - parse a csv file and write output to another csv file with Google Charts . I want to get csv file from yahoo finance and use PHP to

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

2014-09-03 Thread Andrew Gallant
Try setting the focusTarget option to category. This will add all of your data points at a particular x-axis value to the tooltip. On Tuesday, September 2, 2014 7:02:48 AM UTC-4, Alexandre Carrie wrote: Hello, I'm using Google Charts in my project. I've something like this :

[visualization-api] Re: Updating chart causes it to shrink

2014-09-03 Thread Andrew Gallant
Are you specifying the dimensions on the chart container or in the chart options? On Tuesday, September 2, 2014 4:08:51 AM UTC-4, Shreepad Patil wrote: Even I am getting a similar issue, this problem appears especially when even when I give the height and width parameters in 'em'. On

[visualization-api] Re: Hover and Selection tooltips on one point

2014-09-03 Thread Andrew Gallant
You cannot have two different tooltips for the same data point, sorry. On Tuesday, September 2, 2014 9:19:31 AM UTC-4, Josh Swanston wrote: I am creating a Bar Chart in google charts. The data that has been input is very simple, integer values. I have configured the chart to have hover over

[visualization-api] Re: Google charts and responsive design for Android...

2014-09-03 Thread Andrew Gallant
When you say the axis gets truncated, do you mean that some of the labels are disappearing (as an example, every other label disappears), or is part of the chart itself truncated? On Tuesday, September 2, 2014 10:02:55 AM UTC-4, Enne Dee wrote: Trying to do some simple google charts for

[visualization-api] Re: Stack columns. Issues with custom tooltip.

2014-09-03 Thread Andrew Gallant
1 does indeed appear to be a bug. 2 is because you are specifying the calculated column's properties incorrectly. The object key should be properties not p: cols.push({ calc: createTooltip(i), type: string, role: tooltip, properties: {html: true} }); Tooltip actions are

[visualization-api] Re: GeoChart and Strings problem !!

2014-09-01 Thread 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

[visualization-api] Re: Getting link to the PNG image file without rendering on the web page

2014-09-01 Thread Andrew Gallant
You have to render the chart at least once to get the image/octet stream (that you can view or save as a .png file). Once you have that URI, you can do whatever you want with it (including save it in a database to serve up later). On Sunday, August 31, 2014 6:32:38 AM UTC-4, simran kaur

[visualization-api] Re: Can I query datatable with SQL?

2014-09-01 Thread Andrew Gallant
You can use the DataTable#getFilteredRows method to return an array of row indices that match your filter criteria, and then pass that array to a DataView, which you can then use to draw your chart: // response is the response from your query var data = response.getDataTable(); // get all rows

[visualization-api] Re: Group the legends

2014-08-29 Thread Andrew Gallant
? Thanks Am Freitag, 29. August 2014 00:29:01 UTC+2 schrieb Andrew Gallant: You cannot group your legend items, sorry. You can, however, turn off the legend in the chart and build your own legend in HTML that uses whatever layout you want. On Thursday, August 28, 2014 9:06:30 AM UTC-4

Re: [visualization-api] Re: Line chart with changing view window and 2 x-axis (how do I do this?)

2014-08-29 Thread Andrew Gallant
, 2014 at 6:24 PM, Andrew Gallant agal...@google.com javascript: wrote: It is possible to make a paging system like that which uses a DataView to restrict the visible rows of data. For a pre-packaged solution, however, I suggest taking a look at the ChartRangeFilter https://google

[visualization-api] Re: Bar Chart with 3 sets of data (A bit of a newb)

2014-08-28 Thread Andrew Gallant
, Andrew Gallant wrote: If you post what you've tried so far, I'll help you through the changes you need to make it work. On Wednesday, August 27, 2014 8:29:04 PM UTC-4, tripm...@gmail.com wrote: Hi all, Trying to get The Tea/Coffee example on https://google-developers.appspot.com/chart

[visualization-api] Re: Group the legends

2014-08-28 Thread Andrew Gallant
You cannot group your legend items, sorry. You can, however, turn off the legend in the chart and build your own legend in HTML that uses whatever layout you want. On Thursday, August 28, 2014 9:06:30 AM UTC-4, Schabagh wrote: Hello, is that possible to group the legends? my legend looks

[visualization-api] Re: I'd like to commission someone to write a fairly basic line chart. Interested?

2014-08-28 Thread Andrew Gallant
the blank line is still causing it not to load. With the fix I still have to edit the .csv and backspace once to get it to work. Any ideas? Thanks again, most appreciated! On Saturday, August 2, 2014 8:09:56 AM UTC-7, Andrew Gallant wrote: To fix the issue with the blank line at the end

[visualization-api] Re: Line chart with changing view window and 2 x-axis (how do I do this?)

2014-08-27 Thread Andrew Gallant
It is possible to make a paging system like that which uses a DataView to restrict the visible rows of data. For a pre-packaged solution, however, I suggest taking a look at the ChartRangeFilter https://google-developers.appspot.com/chart/interactive/docs/gallery/controls#chartrangefilter.

[visualization-api] Re: Annotation above stacked columns? Simple way to add additional line to tooltip with same information?

2014-08-27 Thread Andrew Gallant
That requires adjusting the line hack. You can move the points by changing their value, while keeping your formatted value the same to keep the tooltips correct. Add an annotation column after this one to get the labels to display. You cannot make the leader lines go away, but you can hide

[visualization-api] Re: Bug with LineChart HTML Tooltips?

2014-08-27 Thread Andrew Gallant
You have isHtml improperly capitalized in the option declaration: var options = { tooltip: {isHTML:true, trigger: 'selection'}, }; it should be: var options = { tooltip: {isHtml:true, trigger: 'selection'}, }; Variables, functions, and object properties are all case-sensitive in

Re: [visualization-api] Wrapping text of X-axis labels?

2014-08-27 Thread Andrew Gallant
It does not wrap when the text is angled (http://jsfiddle.net/emena01o/2/), which is what is happening in Bryan's chart. To get the labels to wrap, they have to be able to fit along the bottom of the chart in the wrapped state. In your case, this requires some combination of expanding the

Re: [visualization-api] Re: Forcing annotations to appear above stacked column AND above intervals, AND without the bizarre connector?

2014-08-27 Thread Andrew Gallant
Using the new stemLength option (along with a few other adjustments from other threads about your chart), this is what you can get: http://jsfiddle.net/asgallant/s7040rms/18/ On Wednesday, August 27, 2014 3:49:54 PM UTC-4, Sergey wrote: It is not explained anywhere. 1.1 is the prerelease

[visualization-api] Re: Bar Chart with 3 sets of data (A bit of a newb)

2014-08-27 Thread Andrew Gallant
If you post what you've tried so far, I'll help you through the changes you need to make it work. On Wednesday, August 27, 2014 8:29:04 PM UTC-4, tripm...@gmail.com wrote: Hi all, Trying to get The Tea/Coffee example on

[visualization-api] Re: Charts returning QR code instead of line graph

2014-08-26 Thread Andrew Gallant
I perused the examples in the documentation https://google-developers.appspot.com/chart/image/docs/gallery/line_charts, and I didn't see anything out of order. Is the src of that QR code the same as what you would expect for your line chart? On Tuesday, August 26, 2014 8:09:46 AM UTC-4,

[visualization-api] Re: Stacked column/bar charts : Displayed value on each group

2014-08-26 Thread Andrew Gallant
Yes, you need to specify an annotation column for each of your data columns. If you just want to display the value, the easiest way to do this is with a DataView that calculates the annotations for you: var data = google.visualization.arrayToDataTable([ ['API Category', 'Social', 'Music',

[visualization-api] Re: Annotation above stacked columns? Simple way to add additional line to tooltip with same information?

2014-08-26 Thread Andrew Gallant
If you add a new series that is the sum of the previous series, you can plot them all on a ComboChart, using bars series for the columns and a line series for the total. You can make the line invisible by setting the line series' lineWidth and pointSize options to 0. Setting the line series'

[visualization-api] Re: Garbled Chart Legends When Hiding / Showing Charts in Div

2014-08-25 Thread Andrew Gallant
/Demographics/Acalanes-Ridge-CDP-CA-Demographics-data.html Just select the 3rd option (singles) in the Demographics menu item. thanks, anthony On Wednesday, August 20, 2014 6:04:53 PM UTC-7, Andrew Gallant wrote: This is caused by drawing charts inside hidden divs, which breaks

[visualization-api] Re: More than two Y-Axes

2014-08-25 Thread Andrew Gallant
You can get more than 2, but the extras don't work particularly well. The first axis appears on the left, the second and subsequent axes all stack up on the right. From a practical standpoint, you could have 3, with one of the two on the right having the textPosition option set to in and the

Re: [visualization-api] Re: Display total at top of legend in pie chart

2014-08-25 Thread Andrew Gallant
, Andrew Gallant agal...@google.com javascript: wrote: You have a syntax error in that code: you are missing the closing }); for the addListener call. Also, since your example uses a plain chart object instead of a ChartWrapper, you cannot use the #getDataTable method - you must reference

[visualization-api] Re: Charts drawn to a dynamically created container element (DIV) is unresponsive to events.

2014-08-25 Thread Andrew Gallant
Can you provide an example that demonstrates this effect? I made a basic test case, and it works fine: http://jsfiddle.net/asgallant/va4ehd5f/. On Monday, August 25, 2014 8:42:14 AM UTC-4, Bhuvana R wrote: My chart container element is a div that's dynamically added to DOM. I am using it to

[visualization-api] Re: Timelines in js from a google script?

2014-08-25 Thread Andrew Gallant
it. Also tried adding !DOCTYPE html. Thanks for the assistance. On Wednesday, August 20, 2014 5:31:31 AM UTC-7, Andrew Gallant wrote: The only problems I see with that file are that it is missing a !DOCTYPE declaration, and it has an errant comma at the end of the data array: var data

[visualization-api] Re: Garbled Chart Legends When Hiding / Showing Charts in Div

2014-08-25 Thread Andrew Gallant
it is: http://www.towncharts.com/California/Demographics/Acalanes-Ridge-CDP-CA-Demographics-data-workingOn.html The new event handler is on line 380. Thanks for any help. On Monday, August 25, 2014 5:40:30 AM UTC-7, Andrew Gallant wrote: I looked over the code, but I could not find that event

Re: [visualization-api] Re: Display total at top of legend in pie chart

2014-08-24 Thread Andrew Gallant
http://jsfiddle.net/manising/Luwodpg9/ code works on commenting the aggregation part. is the initialization incorrect? On Sun, Aug 24, 2014 at 6:43 AM, Andrew Gallant agal...@google.com javascript: wrote: The ready event handler takes the data used by the PieChart and groups

[visualization-api] Re: Google Chart Timeline floating X-axis

2014-08-23 Thread Andrew Gallant
If you specify a height for the chart's container or in the chart's options , the timeline will be vertically scrollable, with the x-axis fixed at the bottom: http://jsfiddle.net/asgallant/z18ruap9/ On Thursday, August 21, 2014 9:58:51 AM UTC-4, Ákos Kovács wrote: How can I set floating X

[visualization-api] Re: Chart to mimic Google Analytics Realtime Pageviews per second

2014-08-23 Thread Andrew Gallant
:25 AM UTC-4, Andrew Gallant wrote: If you have a data source that you can get updates from on some time interval, then you refresh your chart with new data; just add/remove data from the chart's DataTable and redraw. On Wednesday, August 20, 2014 9:20:27 PM UTC-4, Mark Schenkel wrote

[visualization-api] Re: Timelines in js from a google script?

2014-08-23 Thread Andrew Gallant
though, and it still doesn't work when I fix it. Also tried adding !DOCTYPE html. Thanks for the assistance. On Wednesday, August 20, 2014 5:31:31 AM UTC-7, Andrew Gallant wrote: The only problems I see with that file are that it is missing a !DOCTYPE declaration, and it has an errant

Re: [visualization-api] filter for getFilteredRows using multiple values for the same column

2014-08-23 Thread Andrew Gallant
Is that new functionality, Sergey? On Friday, August 22, 2014 10:00:11 AM UTC-4, Sergey wrote: You can use a filter with a 'test' function. Here is an example: http://jsfiddle.net/0h7fxsLu/ On Fri Aug 22 2014 at 2:34:58 AM Bill Shetti bills...@gmail.com javascript: wrote: Hi, Is there

[visualization-api] Re: Timeline: Remove Weekends

2014-08-23 Thread Andrew Gallant
Sorry, but you cannot remove the weekends from the timeline. On Friday, August 22, 2014 7:14:20 PM UTC-4, Tito wrote: Actually, the gaps aren't being caused by the chart, they are being caused by my data. However, the current charting will still display data for the weekends (if i have

[visualization-api] Re: Chart to mimic Google Analytics Realtime Pageviews per second

2014-08-21 Thread Andrew Gallant
If you have a data source that you can get updates from on some time interval, then you refresh your chart with new data; just add/remove data from the chart's DataTable and redraw. On Wednesday, August 20, 2014 9:20:27 PM UTC-4, Mark Schenkel wrote: Is there a chart type that could best

[visualization-api] Re: doesn't work visualization(PieChart and LineChart) IE8. Help????????????????????????

2014-08-21 Thread Andrew Gallant
.org/TR/xhtml1/DTD/xhtml1-transitional.dtd http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd* at the top of the page. AJAX function sresponse return greater than 0 . Still Didn't work IE8 On Tuesday, August 19, 2014 6:46:07 AM UTC+6:30, Andrew Gallant wrote: I don't see anything

[visualization-api] Re: chart does not appear when using from a server but, appears when opening file directly into browser

2014-08-21 Thread Andrew Gallant
The API loader works fine over both HTTP and HTTPS, so I don't think that is your problem. There is a Flash security issue that prevents the AnnotatedTimeline chart from drawing when loaded locally instead of from a webserver. The AnnotatedTimeline chart is deprecated, though - I suggest

[visualization-api] Re: Visulization API version

2014-08-20 Thread Andrew Gallant
You should use version 1, which is always the most current release. Version 1.1 is for the release candidate, which may not be stable. On Wednesday, August 20, 2014 1:48:13 AM UTC-4, Shivani Kanakhara wrote: Which Visulization API version should be used? 1.0 or 1.1 ?? In case of using

Re: [visualization-api] Charts deprecation

2014-08-20 Thread Andrew Gallant
The deprecation policy states that Google will continue to provide service for deprecated API's and components for 3 years from the date of deprecation. After 3 years, access could be turned off at any time. The Visualization API team's goal with deprecated components is to replace them with

[visualization-api] Re: Timelines in js from a google script?

2014-08-20 Thread Andrew Gallant
this is being pulled in by the HtmlService that I can test? On Wednesday, August 20, 2014 2:24:47 AM UTC-4, Mackey McCandlish wrote: Here is the html, it is just an example from the visualization samples, wrapped in htmlbody. On Tuesday, August 19, 2014 4:11:40 PM UTC-7, Andrew Gallant wrote

[visualization-api] Re: print out high resolution

2014-08-20 Thread Andrew Gallant
Resolution translates directly into image size, as pixels in a browser have fixed physical dimensions for any given screen size, resolution, and scaling (browser pixels do not necessarily map 1:1 to screen pixels). The Visualization API is not aware of (and cannot be made aware of) the

Re: [visualization-api] Re: print out high resolution

2014-08-20 Thread Andrew Gallant
/10/ before to convert it to an image/octet stream. 2. Is there a way to create a big chart without affecting what is display on the screen? On Wed, Aug 20, 2014 at 3:50 PM, Andrew Gallant agal...@google.com javascript: wrote: Resolution translates directly into image size, as pixels

[visualization-api] Re: Donut charts with a single value don't show the value

2014-08-20 Thread Andrew Gallant
It is showing the label - in the center of the slice. The default label color is white and the default background color is white, so the label is not distinguishable from the background. If you change the text color, it shows up: http://jsfiddle.net/asgallant/mx03tcx5/ On Wednesday, August

[visualization-api] Re: i have problem changing this to native javascript

2014-08-20 Thread Andrew Gallant
This forum is for the Google Visualization API, while your code uses Highcharts. You will likely have better luck asking on the Highcharts forum http://forum.highcharts.com/. On Wednesday, August 20, 2014 11:18:29 AM UTC-4, anuj joshi wrote: private native void createChart() /*-{

[visualization-api] Re: Non-geographic heat map.

2014-08-20 Thread Andrew Gallant
You can co-opt the ColumnChart to do that for you: http://jsfiddle.net/asgallant/kpnpvank/1/ On Wednesday, August 20, 2014 4:31:08 PM UTC-4, Bryan Maloney wrote: Since Google API doesn't support phylograms (and certainly not unrooted trees), is there a way I can do a distance matrix-based

[visualization-api] Re: specifying N number of x-axis when data is only one

2014-08-20 Thread Andrew Gallant
You have to format the timeofday column. There are no built-in formatters for the timeofday data type, but you can hijack the DateFormatter for the purpose: var formatter = new google.visualization.DateFormat({pattern: 'h:mm a'}); var timeSteps = ['hours', 'minutes', 'seconds',

[visualization-api] Re: ng-google charts and formatter pattern for time

2014-08-20 Thread Andrew Gallant
For reference in case someone searches this out, the answer is over in this thread https://groups.google.com/d/msg/google-visualization-api/FMMZBMR-uyc/22A61Ynh-rEJ . On Wednesday, August 20, 2014 6:59:47 PM UTC-4, Neil Camara wrote: Hi folks, Is anyone here using ng-google charts in

[visualization-api] Re: Garbled Chart Legends When Hiding / Showing Charts in Div

2014-08-20 Thread Andrew Gallant
This is caused by drawing charts inside hidden divs, which breaks the Visualization API's internal dimension detection algorithms. The solution is to draw the charts before hiding them, or to draw the charts when their containers are first opened. On Wednesday, August 20, 2014 8:59:28 PM

Re: [visualization-api] Re: Display total at top of legend in pie chart

2014-08-19 Thread Andrew Gallant
/td /tr /table /div div /div /body /html Thanks, Manish On Tue, Aug 19, 2014 at 5:21 AM, Andrew Gallant agal...@google.com javascript: wrote: The charts do not support adding a total anywhere, but you can calculate it yourself, add it to your DOM, and use

[visualization-api] Re: Timelines in js from a google script?

2014-08-19 Thread Andrew Gallant
, 2014 5:18:09 PM UTC-7, Andrew Gallant wrote: Is the chart code in the file you load through the HtmlService.createHtmlOutputFromFile call, or is it in apps script? On Monday, August 18, 2014 10:31:46 AM UTC-4, Mackey McCandlish wrote: I've been able to create charts in javascript and display

[visualization-api] Re: Question about creating a timeline

2014-08-19 Thread Andrew Gallant
this myself so I don't have to be reliant on you? :P) On Tuesday, August 12, 2014 6:51:55 PM UTC-4, Andrew Gallant wrote: You have to convert your Timeline into a ChartWrapper in order to use it with a Dashboard: var chart = new google.visualization.ChartWrapper({ chartType

[visualization-api] Re: How do I increase the accuracy of my pie chart? 99.9% -- 99.99%

2014-08-19 Thread Andrew Gallant
The pie slice percentages are not configurable, sorry. You can make a feature request http://code.google.com/p/google-visualization-api-issues/issues/list to add support for this. On Tuesday, August 19, 2014 10:54:53 AM UTC-4, Kevin Machado wrote: I have a few pie charts that pull from a

[visualization-api] Re: google charts webmatrix

2014-08-19 Thread Andrew Gallant
This: var jsonData = $.ajax({ url: teste.cshtml, dataType:json, async: false }).responseText; produces a string, not a javascript object. You need to parse the JSON into an object before you can use it with the function Sergey wrote: var data = jsonToTable(JSON.parse(jsonData),

[visualization-api] Re: drawing box plot in using google chart api

2014-08-19 Thread Andrew Gallant
A box plot typically involves plotting quartiles (or some other interval). If you are planning on plotting them, how will they be derived from your data? If not, then a box plot isn't really what you are looking for; can you provide an example of what you want to achieve? On Tuesday, August

[visualization-api] Re: drawing box plot in using google chart api

2014-08-19 Thread Andrew Gallant
candlesticks directly. I will use the lowest value as low, highest value as high, 25th percentile as opening and 75th percentile as closing. I just have to figure out how to use the median. But thank you anyway. On Tuesday, August 19, 2014 5:56:51 PM UTC-6, Andrew Gallant wrote: A box plot

[visualization-api] Re: ChartWrapper.draw() can produce a JavaScript warning in Firefox

2014-08-18 Thread Andrew Gallant
*. In Firefox, this causes a JavaScript warning (not an error). Not a critical issue, but annoying. On Sunday, August 17, 2014 9:33:02 AM UTC-4, Andrew Gallant wrote: Yes, and it should pass that error. You cannot draw a chart if you do not provide the target container's ID. On Saturday, August

[visualization-api] Re: Display total at top of legend in pie chart

2014-08-18 Thread Andrew Gallant
The charts do not support adding a total anywhere, but you can calculate it yourself, add it to your DOM, and use CSS to position the total over the chart wherever you need it. You can calculate it like this: google.visualization.events.addListener(barChart, 'ready', function () { var dt =

Re: [visualization-api] Re: Table and map in same dashboard

2014-08-18 Thread Andrew Gallant
at 1:28 AM, Andrew Gallant agal...@google.com javascript: wrote: Add those styles to a style sheet or in a style tag. You need to have a div with the class clearFloat after your controls for it to work (see the example HTML). On Thursday, August 14, 2014 10:07:19 AM UTC-4, Sikker Trafik

[visualization-api] Re: Mutiple records to Google Charts

2014-08-18 Thread Andrew Gallant
: Yes, but if I remove the $rows = array(); line from the loop, I get an empty json file. 2014. augusztus 17., vasárnap 15:31:58 UTC+2 időpontban Andrew Gallant a következőt írta: You are overwriting $rows every time though the loop: $rows = array(); Remove that line from the while loop

[visualization-api] Re: Range selector Annotation Chart

2014-08-18 Thread Andrew Gallant
Your AnnotatedTimeline chart looks like it was drawn with a much longer time series - what do you see with the AnnotationChart when you draw with the same data set? On Monday, August 18, 2014 5:53:42 AM UTC-4, Shivani Kanakhara wrote: The hAxis of range selector in Annotation Chart changes

[visualization-api] Re: doesn't work visualization(PieChart and LineChart) IE8. Help????????????????????????

2014-08-18 Thread Andrew Gallant
I don't see anything in there that would cause IE 8 to fail. Do you have a !DOCTYPE declaration at the top of your page? If not, you need one. If you have one, what do your AJAX functions return? On Monday, August 18, 2014 5:59:01 AM UTC-4, pya...@2c2p.com wrote: script

[visualization-api] Re: Timelines in js from a google script?

2014-08-18 Thread Andrew Gallant
Is the chart code in the file you load through the HtmlService.createHtmlOutputFromFile call, or is it in apps script? On Monday, August 18, 2014 10:31:46 AM UTC-4, Mackey McCandlish wrote: I've been able to create charts in javascript and display them from my googlescript app, by using an

<    1   2   3   4   5   6   7   >