[visualization-api] How do I ensure the baselines for a dual-axis chart match up with one another?

2014-10-08 Thread bspwg1
I have a Google Combination Chart where I am using two y axes. At present, the baselines for each axis are at a different level. I wish to ensure that the baselines for each axis are at the same level. The code I am currently using to display my graph is shown below: html head

[visualization-api] Google GeoChart Visualization API - city plotting in wrong location

2014-10-08 Thread mctenold
For some reason on a site I'm working on, San Francisco is placing a marker in Louisiana in a Google GeoChart Visualization. I've even tried changing it to San Francisco, CA, and even San Francisco, CA, USA and it's still plotting it in Louisiana. You can see the incorrect marker here:

Re: [visualization-api] Google GeoChart Visualization API - city plotting in wrong location

2014-10-08 Thread 'Sergey Grabkovsky' via Google Visualization API
Hi, the GeoChart uses the first column for geocoding, not the second column. I'm not sure what prompted you to enter 'san-francisco-2', but changing it to 'san-francisco' seems to fix the problem. You should enter descriptive locations in the first columns, and what you want to display in the

Re: [visualization-api] Google GeoChart Visualization API - city plotting in wrong location

2014-10-08 Thread mctenold
Gotcha, That is the category slug, I'm just using it for filtering purposes. I'll rearrange the data and see how that works. Thank you! On Wednesday, October 8, 2014 3:31:14 PM UTC-4, Sergey wrote: Hi, the GeoChart uses the first column for geocoding, not the second column. I'm not sure

Re: [visualization-api] Google GeoChart Visualization API - city plotting in wrong location

2014-10-08 Thread mctenold
Just rearranged the data, that worked. Thanks Sergey! On Wednesday, October 8, 2014 3:31:14 PM UTC-4, Sergey wrote: Hi, the GeoChart uses the first column for geocoding, not the second column. I'm not sure what prompted you to enter 'san-francisco-2', but changing it to 'san-francisco'

[visualization-api] TableChart is showing full screen or How to setup width to 100%

2014-10-08 Thread Rajiv Goswami
I have created this web app. Working fine. However, Table Charts show in half od t he screen. How can I make it to display its true width? Here us Link to App https://script.google.com/macros/s/AKfycbzvq30iPr7t2YjisSLIZ_9xyftsEYQ6bNmVtNQ40_8/dev I am attaching TXT file which has my code. Please

Re: [visualization-api] TableChart is showing full screen or How to setup width to 100%

2014-10-08 Thread 'Daniel LaLiberte' via Google Visualization API
Rajiv, There should be a 'width' option that you can set to '100%'. I can't see the App page you linked to, not without your permission, which I requested. But since it is an AppsScript app, you might need to ask the AppsScript folks for how to set the option, if you can't figure it out from

Re: [visualization-api] Re: Timeline - x-axis - Scale or ScrollBar

2014-10-08 Thread Andrew Gallant
Here's an example: http://jsfiddle.net/asgallant/y5nw5ow8/ On Sunday, October 5, 2014 12:50:36 AM UTC-4, ss kumar wrote: Hi, Thanks for ur reply. Could you reply sample code on how to use it? Thanks. On Fri, Oct 3, 2014 at 7:26 PM, Andrew Gallant agal...@google.com javascript: wrote:

[visualization-api] Re: Columns with a colored top section

2014-10-08 Thread Andrew Gallant
You can do something quite similar by creating a DataTable with 4 columns: domain (axis labels), value (for the height of the lower bars), box thickness (for the height of the colored boxes), and color: var data = google.visualization.arrayToDataTable([ ['Label', 'Value', 'Box thickness',

[visualization-api] Re: labels and shading for area charts

2014-10-08 Thread Andrew Gallant
You can't change the placement of the annotation except to place it at a different data point. Are you using a discrete (string-based) or continuous (number, date, datetime, timeofday based) domain axis? On Monday, October 6, 2014 11:27:26 AM UTC-4, John Hughes wrote: Andrew, Thanks the

[visualization-api] Re: Chart Size Within Parent Container

2014-10-08 Thread Andrew Gallant
Can you post some code that replicates the problem? On Tuesday, October 7, 2014 2:40:09 PM UTC-4, Matheus Henrique Klem Galvez wrote: I forgot to mention that it happend with two types of charts: line and column chart. On Tuesday, October 7, 2014 3:36:44 PM UTC-3, Matheus Henrique Klem

[visualization-api] Re: How do I ensure the baselines for a dual-axis chart match up with one another?

2014-10-08 Thread Andrew Gallant
If having the baseline always be in the center of the chart is acceptable (even when there are no data points below it), there is an easy solution to this problem: get the min/max for each series and set the minValue/maxValue options to the negative of the opposite value: this will ensure that

[visualization-api] Re: Parse json data to google visualisation api

2014-10-08 Thread Andrew Gallant
PieCharts use 1 string and 1 number column only - they cannot use extra data, so you will have to decide which series are appropriate to use. You can create a DataView to restrict the data the chart sees to a particular subset of columns, so you don't have to change your DataTable construction

Re: [visualization-api] TableChart is showing full screen or How to setup width to 100%

2014-10-08 Thread 'Daniel LaLiberte' via Google Visualization API
OK I looked, but I can't make any sense of the generated code (in the browser). You'll need to find out how AppsScripts should let you specify the options for the chart, and include that 'width' option On Wed, Oct 8, 2014 at 7:55 PM, Daniel LaLiberte dlalibe...@google.com wrote: Rajiv, There

[visualization-api] Query speadsheet -dates greater than or equal to the date today

2014-10-08 Thread Robert Finch
Hello. I have a spreadsheet with names and dates: https://docs.google.com/spreadsheets/d/1vi3Yg2mPUyTCG6eWFaTeYFSvHKwSYidZexT866xlBSE/edit?usp=sharing I would like to query names with dates greater than or equal to the date today. I have tried the following: SELECT A, B WHERE B = today()

Re: [visualization-api] Re: Timeline - x-axis - Scale or ScrollBar

2014-10-08 Thread ss kumar
I got it using DateRangeFilter, below example link, but this looks awesome. Thank you so much!! https://google-developers.appspot.com/chart/interactive/docs/gallery/controls_2444e4a8cb86629c942b892146ce446e.frame Could you please let me know whether it is possible to customize ToolTip data for