[visualization-api] Google Sheets and Controls and Dashboards

I want to use as StringFilter from "Controls and Dashboards ". The problem is, I don't know how connect to the Google Sheet I want to use. Almost everything else I've wanted to do with the charts I have managed to find a

[visualization-api] Re: Hide a column

Thank you again Daniel. I'm already using the visualizations on my employer's website. Luckily for me they require very little user interaction and the data is well formatted. Using it on my hobby site is a way of checking I properly understand what's going on should they require user

[visualization-api] Hide a column

I have run into a problem only showing certain columns from the data in a table. A have data in 5 columns, when it displays I do not want column 5 (index 4) to display. There's several methods I tried: setColumns([0, 1, 2, 3]); removeColumn(4); setView({'columns': [0, 1, 2, 3]}); view:

[visualization-api] Conditionally Apply PatternFormat to Visualization

Taking the code at https://developers.google.com/chart/interactive/docs/reference#patternformatter as an example. The data looks like this data.addRows([ ['John Lennon', 'j...@beatles.co.uk'], ['Paul McCartney', 'p...@beatles.co.uk'], ['George Harrison', 'geo...@beatles.co.uk'],

[visualization-api] Re: Google Sheets and Controls and Dashboards

It seems I got myself confused. I had another look at this and I think it was the JSON methods that were described but which I didn't need. I used the GID method of connecting to the spreadsheet - https://developers.google.com/chart/interactive/docs/spreadsheets to get the data I needed

[visualization-api] Re: Conditionally Apply PatternFormat to Visualization

Thanks Daniel, I've been rereading the documentation and think I see what I need to do. Get the total number of rows using var totalrows = crewDataTable.getNumberOfRows(); I know there are only 5 columns in the original data, and the URL I want is in the last of those. There's only 30 of

[visualization-api] Re: Google Charts Timeline driven by Google Sheet Example?

Here's an example based on the Presidents example in the docs - https://jsfiddle.net/brisray/j8nfu9a2/ Here's the spreadsheet it's coming from - https://docs.google.com/spreadsheets/d/1XqI6BGA5uBioeZza1KxxsXeTT4VHJbLhGBz06h9Rv_U/edit#gid=0 All you need do is create a query, send it, handle

[visualization-api] Re: Where should i put printable version of google chart code on my javascript

The code goes just before the draw method. You also need to add a new div in the HTML to hold the image or link to it. https://jsfiddle.net/brisray/L01cxut6/ - This shows the code to draw the chart https://jsfiddle.net/brisray/L01cxut6/3/ - This shows the chart and an image of the chart (the

[visualization-api] Re: http://www.gstatic.com/charts/loader.js is free???

This is how I understand the agreements work: There is no license requirement for the API at all, not for commercial, non-profit or private use. It is free to use, but not open source. You cannot try and download the libraries to run them from your own servers, you have to link to the Google

[visualization-api] Re: matchType in CategoryFilter?

It's done and was much easier than I first thought. I wanted to keep the original datatable so needed to create a new dataview, I thought I might have to step through the datatable in a loop to create a new dataview but after re-reading the docs found I didn't have to. I added my own select

[visualization-api] matchType in CategoryFilter?

Before I start trying to write my own function, is there something similar to the matchType option in StringFilter that can be applied to CategoryFilter? Something similar to Awesome Table's csvFilter - https://support.awesome-table.com/hc/en-us/articles/115001068189-Available-filters#6 I know

[visualization-api] Where does JS execution begin again after drawing charts?

Just when I thought I was getting ahead with the Visualizations, I find I'm not. https://jsfiddle.net/brisray/qsgewt2d/ - works as far as I have it, but I have a question about it. Once the graphs are drawn, I assumed that control would pass back to "mainFunction". This is a function that

[visualization-api] Re: Where does JS execution begin again after drawing charts?

I'm not sure that is the solution, or if it is, I don't see how. The dropdowns to change the graph type work properly. but if I add for (i = 0; i < graphArray.length; i++) { graphArray[i].graphtype = "Bar"; drawGraphs(graphArray[i]); to the mainFunction then Chrome's debugger

[visualization-api] Re: Where does JS execution begin again after drawing charts?

I'm not sure if that's what is going on - or if it is I don't see how. The dropdowns to change the graph type appear to work properly, but if I add for (i = 0; i < graphArray.length; i++) { graphArray[0].graphtype = "Bar"; drawGraphs(graphArray[0]); } to the mainFunction

[visualization-api] Re: Please test: testing-loader.js

I use Chrome 58, Firefox 52, IE 11, Edge 38 and here's what I found http://hmsgambia.org/crewlist.htm (original) https://www.gstatic.com/charts/loader.js";> google.charts.load('current', {packages:['corechart', 'table', 'gauge', 'controls']});

[visualization-api] Re: Please test: testing-loader.js

and for the sake of completeness: http://hmsgambia.org/crewlist4.htm https://www.gstatic.com/charts/loader.js";> google.charts.load('current',{ packages: ['corechart', 'table', 'gauge', 'controls'] }).then(drawChart); Chrome = No, Firefox = No, IE = No, Edge = No - Table does not

[visualization-api] Re: Interactive charts

Yes it does, the user can choose a range of data to display. You need to look at the "Controls and Dashboards" section of the documentation - https://developers.google.com/chart/interactive/docs/gallery/controls Something you may find useful is the ability to, once the data has been

[visualization-api] Re: Interactive charts

Yes it does, the user can choose a range of data to display. You need to look at the "Controls and Dashboards" section of the documentation - https://developers.google.com/chart/interactive/docs/gallery/controls Something you may find useful is the ability to, once the data has been

Re: [visualization-api] Re: Please test: testing-loader.js

It works on IE and Edge for me now as well. Ray -- 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

[visualization-api] Re: Where does JS execution begin again after drawing charts?

Thank you for looking at this This function and the loop in it started out as something just for me to quickly cycle through the various types of charts to see which ones would look better and make more sense if the datatable were transposed. It turned out less trivial than I first thought, so

Re: [visualization-api] Re: Dynamic google chart generation using php

One problem you might run into depending on the size of your data. My JS array keeps a copy of the datatable so they can be reused to redraw the graphs. I should imagine if you do that with a lot of large tables you'll run into memory problems. As you're using PHP one solution might be to

[visualization-api] Re: Google Charts 'upcoming' release of v45.2

I tested 'upcoming' at https://jsfiddle.net/brisray/fux0vgLm/ and http://hmsgambia.org/crewlist5.htm with no problems. Unlike Hartmut I had no problems with using tooltip: with both boxStyle: and textStyle: together - https://jsfiddle.net/brisray/fux0vgLm/1/ Maybe a missing comma when adding

Re: [visualization-api] Re: Dynamic google chart generation using php

I didn't answer before as I don't know enough about PHP to help you with any code, but what you want to do is surprisingly straightforward. Create an array to hold your variables Loop through that to create the HTML, create the query to Google Visualizations and draw the graphs. There's

[visualization-api] Re: Google Charts 'upcoming' release of v45.2

I tested upcoming at https://jsfiddle.net/brisray/wgzz8xx5/ and http://hmsgambia.org/crewlist5.htm with no problems Unlike Hartmut I had no problems with using both tooltip: boxStyle: and tooltip: textStyle: together - https://jsfiddle.net/brisray/wgzz8xx5/1/ Ray -- You received this message

[visualization-api] Re: Where does JS execution begin again after drawing charts?

I abandoned what I was trying to do, which was to step through a list of various chart types to see what would be the best for what I wanted to display. One of the things I wanted to look at was to create PNGs of the various charts. But, I ran foul of the "ready" event handlers again. Just

[visualization-api] Re: Areachart instead of LineChart

It works for me just by changing chartType: 'LineChart', to chartType: 'AreaChart', https://jsfiddle.net/brisray/oLb5dwz5/ > -- 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] Re: Areachart instead of LineChart

It should be AreaChart not ChartArea. It works for me just by changing chartType: 'LineChart', to chartType: 'AreaChart', https://jsfiddle.net/brisray/oLb5dwz5/ -- You

[visualization-api] Sheet formatting showing up in chart axis

Something I hadn't noticed before but sometimes the formatting of the Google Sheet shows up in the axis labels of the Google Visualizations charts. What was happening before I changed the Sheet formatting from "General" or "Automatic" to one of the Numeric options was that the charts started

[visualization-api] Re: ColumnChart - best way to move month to x axis

I really don't know a way using the configuration method but you can do it relatively easily by using code. The function everyone seems to post was originally written by Bhuman Soni at http://captaindanko.blogspot.com/2013/05/transpose-of-google-visualization-data.html and appears on Stack

Re: [visualization-api] Sheet Examples Do Not Work

It works for me in Chrome 61, Firefox 55, IE 11 and Edge 40. I don't know is this applies to you, but a colleague was once unable to view any Google Chart in Chrome but that was because of some extension she had installed. I copied and pasted your code to http://brisray.com/test/werner.htm

[visualization-api] Re: How to rotate points in charts based on values from a google CHARTS

The weather chart I found looked a little like that except for where I live and that gave me the idea for using point styles. A quick search showed that being able to use other shapes or images in the visualizations has come up before -

[visualization-api] Re: How to rotate points in charts based on values from a google CHARTS

I sort of got this to work, but it might not behave as you expect. One of the problems being the triangles are equilateral so it's not clear in which direction they are actually pointing. The documentation at https://developers.google.com/chart/interactive/docs/points and

[visualization-api] Re: Getting unhelpful "error" message when trying to draw Gantt chart

> > Try taking out the "null" in the Google sheet and leaving it blank. > My sheet - https://docs.google.com/spreadsheets/d/14Ga_ybEFiZnB8a8O9zS0sc3_aRaUog0DBS096ZknYb8/edit#gid=0 MY JSFiddle - https://jsfiddle.net/brisray/7qnk55ur/5/ The date columns must also be set to format date Ray --

[visualization-api] Re: gantt chart

It depends on where the data is kept. If it comes from a Google Sheet then you can give various people permissions to edit the sheet. Unless you've specified which columns and rows are getting imported in the code then changes to the spreadsheet take effect as soon as the page is refreshed in

[visualization-api] Re: Format API output

Using the Visualizations API, there's hardly anything in a table that cannot be changed, either using CSS or the formatters. To use a Google Sheet in the visualizations see https://developers.google.com/chart/interactive/docs/spreadsheets#creating-a-chart-from-a-separate-spreadsheet - most of

[visualization-api] Re: How To Show Dual Dashboard Google Chart In One Page

So far as I know you can have as many charts on one page as you like, but you have to some sort of plan to do it. It is important to remember that you can only have one call to the loader.js. You also need to change some of the function and variable names so that they are unique and each must

[visualization-api] Re: Combining a chart with a table

A table in Google Charts is drawn in the same way as a graph and can use the same data. Create divs to hold the graph and the table then simply draw them both in nearly the same way. two divs - chart_div and table_div 1 data table - data Draw the chart and table: var chart = new

[visualization-api] Re: line chart to only display the last "X" number of lines

It would be nice if there was a query that could do this when the Sheet is first read, but as far as I know there is not. One solution is to download all the data then work on the datatable before you display it. The methods that can be used are at

[visualization-api] Re: Múltiples Gráficos

Yes you can, just use google. charts. load ( 'current' , { 'packages' : [ 'corechart' ,"lines']}); You can add other packages to the array as well. For many of the charts you just need corechart. When I wrote https://www.indstate.edu/business/metrics all I used to load the libraries was

[visualization-api] Re: Múltiples Gráficos

Yes you can, just use google. charts. load ( 'current' , { 'packages' : [ 'corechart' ,'lines']}); You can add other packages to the array as well. For many of the charts you just need corechart. When I wrote https://www.indstate.edu/business/metrics all I used to load the libraries was

[visualization-api] Re: Almost there... Help with Visual API Google sheet to HTML formatted with CSS class names

Unfortunately not all the CSS properties for all the charts are available through the API. So here's one solution. Nearly all browsers have some sort of developer tools that let you inspect the CSS for every element on a page - see https://www.lifewire.com/web-browser-developer-tools-3988965

[visualization-api] Re: Specific Colors Pie Graphic

I couldn't get the role colors to work in the pie chart, so I tried a different approach and replaced the entire Google color array with one of my own. https://www.gstatic.com/charts/loader.js";> google.charts.load("current", {packages:["corechart"]});

[visualization-api] Re: Converting a table from AnyChart

I'm not quite sure what you want to do but once you have a datatable, it can be manipulated to create a dataview, and then can either be displayed as a table or charts created from it. Each cell in the table can contain two values, the actual value and a formatted value, and operations can be

[visualization-api] Re: How to extract values from a row into a column on a different sheet?

This probably belongs in the Google Docs forums - https://productforums.google.com/forum/#!forum/docs - than here and your file was not attached, but to get you started you can copy and transpose an entire section of a sheet using: 1) To the same tab in a sheet put this in the top left cell

[visualization-api] Re: How to extract values from a row into a column on a different sheet?

Meropi, something turned up yesterday in the Google Docs forum that may be able to help you. Someone wanted to transpose several sheets but keep them grouped by date and an ID number - https://productforums.google.com/forum/#!topic/docs/PxWFYY3BKjg;context-place=forum/docs The solution is a

[visualization-api] Re: Format API output

> > >> The API treats tables as a type of chart, so you add the code to get the Sheet then "draw" the table. About the simplest I can make it is at https://jsfiddle.net/brisray/Lp01usoz/ That uses the Sheet at

[visualization-api] Re: hyper link in the data table.

Yes you can. Once I've got the table I use .getNumberOfRows() to get the number of rows, then loop through the table getting the values I need from it using .getValue and use .setCell to change the formatted value. Those methods are described on

[visualization-api] Re: hyper link in the data table.

Hello Brian, I think I may have misled you. I had a look through your earlier posts and tried to recreate what you are trying to do. Adding links to the data only appears to work if the the chart type is a table. I also had a look at the huge gap between the control and the chart. I have no

[visualization-api] Re: Eleminate RED color in Google Stacked bar charts

One way is to use the method described at https://developers.google.com/chart/interactive/docs/customizing_charts and to create your own palette in the graph's options. Google's default palette is at https://github.com/ankane/chartkick/issues/351, you can simply paste the values into the

[visualization-api] Re: can I get help rearranging the columns in a google chart?

Are you using a Google Sheet to hold the chart? If you are you can use ORDER BY in the query to get the table. The help for that is at https://developers.google.com/chart/interactive/docs/querylanguage#order-by there's more at https://developers.google.com/chart/interactive/docs/spreadsheets

[visualization-api] Re: LINK GOOGLE SHEET DATA TO LINE CHART -

As most of what you need is in your index.html file anyway it may be an idea to remove the GS code altogether, or at least the getSpreadsheetData() function and use the API's query to connect to and get the data from the spreadsheet. There's a complete example at

[visualization-api] Re: NOOB - where to get started

Using a Google Sheet with Google Visualizations is relatively easy. The documentation you need is at https://developers.google.com/chart/interactive/docs/spreadsheets#creating-a-chart-from-a-separate-spreadsheet all the other options in the documentation will work, just where the data comes

[visualization-api] Re: How to link the info from texboxes to the google chart (bars)

I'm not sure if this helps you specifically, but I can think of two ways text boxes can be linked to Google Charts. Because of the way some of the sites I use are set up, some are CMSs which I have only limited access to, so I mostly use Google Sheets to hold the data, but the principles should

[visualization-api] Re: Invert rows with columns on DataTable

As far as I know, the easiest way to do it is to the use the code from https://stackoverflow.com/questions/16949993/inverting-rows-and-columns-on-google-area-chart which in rturn comes from Bhuman's code at http://captaindanko.blogspot.com/2013/05/transpose-of-google-visualization-data.html

[visualization-api] Re: Color?

Andrian is absolutely correct but here's a fuller explanation. The colors can be defined for any graph either in the Options section or in the main draw() method. The help for both is at https://developers.google.com/chart/interactive/docs/customizing_charts The default color array for Google

[visualization-api] Re: Timeline Error

It's probably because your end time Mon Jul 01 2019 00:15:00 is earlier than your start time Mon Jul 01 2019 22:25:00 > -- 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

[visualization-api] Re: Timeline - How to Control Width of Row Label.

I don't think there is. The column is "dumb" in that everything, HTML, escape codes, character codes and so on, are all treated as text, so there's no way to control it. Requests to change this behavior have been made for years before this thread was started, for example on GitHub -

[visualization-api] Re: Repeated Y-Axis Labels on Stacked Material Chart

It's odd behavior to show the y-axis like that but one way around it is to set the font size to 0 for those axis. Another method I've seen used is to set the font color to match the background, but I think setting the font size to 0 is the better of the two. 2: {

[visualization-api] Re: Timeline chart tooltips.

Until I can find a better method, what I did was to step through the datatable and create a new one with the columns set up in the tooltips help of the Timeline page - https://developers.google.com/chart/interactive/docs/gallery/timeline#customizing-tooltips. Now I know what I am doing I

[visualization-api] Re: Timeline chart tooltips.

Until I can find a better method, what I did was to step through the datatable and create a new one with the columns set up in the tooltips help of the Timeline page - https://developers.google.com/chart/interactive/docs/gallery/timeline#customizing-tooltips. Now I know what I am doing I

[visualization-api] Re: Repeated Y-Axis Labels on Stacked Material Chart

Hi Drew, I did wonder about that when I saw the graph but I can't recall seeing an example of showing such disparate values properly on the same chart. If it is not possible, there are two methods that may work. Some charts allow use of the "explorer" option. This allows users to zoom in on a

[visualization-api] Re: How to make a table with Google Sheets data using Google Charts API

An easier way to do what you want to do is to use the examples on https://developers.google.com/chart/interactive/docs/spreadsheets and https://developers.google.com/chart/interactive/docs/gallery/table Using the examples you can see you have to load the table package by using

[visualization-api] Re: SIMPLE DATE QUERY

A little extra, suppose your cell B1 really does contain '=5 or < 7 or something of that sort, then you can use =QUERY(A:A, "select * where Month(A) "&"") I made a small Sheet of the examples I used at

[visualization-api] Re: [Google Timeline] How to compress hAxis data with time(minutes) in Google Timeline?

I don't think there is. The Timelines are largely automatic without the number of options available in some other charts. I tried a couple of methods but the closest I came to what I think you want was by adding a 1 second event to the end of the day using [ 'Petunia Room', '', new

[visualization-api] Re: SIMPLE DATE QUERY

Try =QUERY(A:A, "select * where Month(A) = 5") Where A is the column of dates. In lots of instances months and days start from 0, not 1. So 5 would return those dates in June, 6 would return the dates in July. Sheet, column A 06/29/2019 06/29/2019 06/30/2019 07/01/2019 07/01/2019 07/02/2019

[visualization-api] Re: Query Function

An old thread but this should work =Query(range,"Select C, sum(E) where C contains 'LIM67' and not C contains '+' group by C") -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving

[visualization-api] Re: Timeline min/max viewable range

This thread is over a year old but I recently came across the same problem and eventually got it to work the way I wanted. What I had was a list of people and their start and end dates of working the the university college I work for. What I wanted was to show everyone who worked between user

[visualization-api] Re: SIMPLE DATE QUERY

OK, suppose your column A contains the dates and cell B1 contains the number of the month you want, then you can use =QUERY(A:A, "select * where Month(A)="&"") It looks a bit strange but that's the way the cell values are referenced in the queries. As a side note, if you use a query like

[visualization-api] Re: how to add attach hyperlinks to google chart

Here's how I do it, I'm not sure if it is the most efficient method, but it works in at least Table Charts. I create a column that contains the text I want to show and another that contains the URL i want the text to link to. You can see that in

[visualization-api] Re: JavaScript code to dynamically switch between isStacked: true and isStacked: 'percent'

This comes up every now and then such as https://stackoverflow.com/questions/21170147/google-charts-switching-between-line-and-column-charts and https://stackoverflow.com/questions/35380994/google-charts-switch-between-table-and-chart-view As you're only changing the value of isStacked you

[visualization-api] Re: How to get a count of words appearing in a column of text fields, sorted by volume

The quickest way I know how to do this is with a query.. Suppose you have your list of words in column A. In cell B2 you can use =query(A2:A,"select A, count(A) where A != '' group by A order by count(A) desc") That adds two new columns, a list with the unique words and in the next column the

[visualization-api] Re: Stacked Bar Chart

Because Google Visualizations and Google Sheets both use Query language - https://developers.google.com/chart/interactive/docs/querylanguage - you can either extract the data you use in the Sheet or do it in the code when drawing the chart. I used your Sheet and used a query in the chart code

[visualization-api] Re: skip 0's and negative values from chart

Try putting nulls or leaving the data out altogether where zero and negative values are and setting interpolateNulls to true. You should end up with something looking like this: var data = google.visualization.arrayToDataTable([ ['Year', 'Massachusetts', 'National'], ['2010', 88,

[visualization-api] Re: Histogram: defining my data?

Hi Yves, I think I know what's wrong. In the data you sent me, in the line ['Akerman Hall' 106.7], there's a comma missing, change it to ['Akerman Hall', 106.7], and it should all work. Ray -- You received this message because you are subscribed to the Google Groups "Google Visualization

[visualization-api] Re: Histogram: defining my data?

You can easily check most of the examples as they're usually in their own frames. Right click somewhere just outside of the graph and choose to view the frame source, copy it to Notepad or other plain text editor, remove the information in the section, and save it to a new html file. You can

[visualization-api] Re: skip 0's and negative values from chart

Try putting nulls where zero and negative values are and setting interpolateNulls to true. You should end up with something looking like this: var data = google.visualization.arrayToDataTable([ ['Year', 'Massachusetts', 'National'], ['2010', 88, 76], ['2011', null,

[visualization-api] Re: adding horizontal,vertical labels to a histogram chart

Hello again Yves, You can add new lines to titles and labels by using \n in the text. BUT - you cannot (as far as I know) easily restyle it. What I did was copy your code and put it at http://brisray.com/test/yves.htm so I could see what I can do to help you. I also tidied up what I wrote

[visualization-api] Re: Vertical Line Graph Issue

I don't know if this is going to work for you but sometimes the way to get the graph to display how you want it to is not to flip the data but to rotate the datatable created from the data. This was written several years ago by Bhuman Soni -

Re: [visualization-api] Re: Histogram: How to make it so that my columns are not divided individually?

It all works but the documentation is a little difficult to understand in places. There's another way of drawing the graphs and that uses an object called ChartWrapper - https://developers.google.com/chart/interactive/docs/reference#chartwrapperobject In that, you can set the options using

[visualization-api] Re: Why are my posts being deleted?

I've had a couple of replies automatically deleted a couple of minutes ago. -- 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

[visualization-api] Re: Histogram: How to make it so that my columns are not divided individually?

You can hide the individual column elements by setting the histogram.hideBucketItems option to true. In your options, use histogram: { hideBucketItems: true }, For the titles and and legends you need to go to

[visualization-api] Re: adding horizontal,vertical labels to a histogram chart

Hello Yves, what you want is var options = { title: 'Efficiency of East Bank Buildings', legend: { position: 'none' }, colors: ['gold'], histogram: { hideBucketItems: true }, hAxis: { title: 'Efficiency (Energy-use intensity/Energy-use per

[visualization-api] Re: adding horizontal,vertical labels to a histogram chart

Cool. These charts really are versatile, but sometimes it's a little bit of work to get them how you want them. Ray -- 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,

Re: [visualization-api] Re: adding horizontal,vertical labels to a histogram chart

Because this is going to be under all the chart elements, I'd be tempted to go back to plain HTML/CSS. Something like this. This is the left-hand description This is the right-hand description -- You received this message because you are subscribed to the Google Groups "Google

Re: [visualization-api] Subdivide a pie chart section

An idea I had when I first read this is to create a custom tooltip for that slice of the pie chart to explain or display the information, even another pie chart, for that slice - https://developers.google.com/chart/interactive/docs/customizing_tooltip_content According to Stackoverflow, if you

Re: [visualization-api] Re: adding horizontal,vertical labels to a histogram chart

Because this is going to under the chart anyway, I'd be tempted to go back to plain HTML/CSS Something like this: This is the left-hand description This is the right-hand description -- You received this message because you are subscribed to the Google Groups "Google

[visualization-api] Re: Comparing data from two years

Hello Lee, What you could do is put the values side by side in almost any of the chart types, but there is also something called a Diff Chart that is good for comparing data - https://developers.google.com/chart/interactive/docs/gallery/diffchart This came up here just a few days ago, so take

[visualization-api] Re: Creating charts from an external Spreadsheet and update data every hour/day(or at a particular time)

First, do you mean a Google Sheet or Excel? Google Sheets are much easier to work with and the charts will update as soon as the sheet is, and the web page refreshed. Excel is going to need a bit more help to work properly and there's very little help around for doing it. There's some at the

[visualization-api] Re: Different color pattern

You need to give an array of color in the options for each chart. That's explained on https://developers.google.com/chart/interactive/docs/customizing_charts What happens is the same as for the default palette, if you have more data than you have defined colors for then they start again at the

Re: [visualization-api] Formatting X axes values in tooltips

Hello Shweta, You really can put whatever you like in the datatable cell used to create the tooltip so long as it's HTML formatted for JavaScript. You can include variables, images, links and even other charts - https://developers.google.com/chart/interactive/docs/customizing_tooltip_content

Re: [visualization-api] heatmap

Given the image looks more like a table and that you can give every cell in a table a CSS class here's something I would try. It looks good in theory and should work. The example at https://developers.google.com/chart/interactive/docs/examples#custom_table_example gets the classname for the

[visualization-api] Re: google.visualization.drawChart JSON response object options?

It should be possible. You can turn both option objects into strings and manipulate them that way using JSON.stringify() to create a single set of options. // Set chart options var options = {'title':'How Much Pizza I Ate Last Night', 'width':400, 'height':300}; myStr =

[visualization-api] Re: Graph and while

Hi Jean-Yves, Problems with drawing multiple charts on a page comes up regularly, and it's usually because of the way scripts work. To show all the charts, you need to either wait until each chart fires its ready event -

[visualization-api] Re: Google Visualization API Sample

Hi Culley, I think it's the authorization key causing this. You'll need to read https://developers.google.com/chart/interactive/docs/spreadsheets#authorization which explains how to obtain your own OAuth credentials. My own preference is to simply make the spreadsheet readable to anyone with

[visualization-api] Re: Study project data visualisation graphics webpage doesn't work

Are you getting any sort of error message in the console? F12 in most browsers and Ctrl+Shift+I in Opera. I can't say for certain but it might be the lines async: false. That's been depreciated - https://xhr.spec.whatwg.org/#the-open()-method and

[visualization-api] Re: Visualization from not shared google spreadsheet

You can use OAuth 2.0 authorization - https://developers.google.com/chart/interactive/docs/spreadsheets#authorization On Thursday, March 4, 2021 at 2:10:16 PM UTC-5 njuha...@gmail.com wrote: > Hello, > > I was searching a lot in google, bud did not find something working. > I am using

[visualization-api] Re: setting column width

What I came up could probably be simplified. It seems a lot of work to extract the row and column numbers from the class names I gave to the cells. var longText = (function() { google.charts.load('current', {'packages':['table']}); google.charts.setOnLoadCallback(drawChart);

[visualization-api] Re: setting column width

What I came up could probably be simplified. There seems to be a lot of code getting the row and column information back out of the class names I gave to the cells. var longText = (function() { google.charts.load('current', {'packages':['table']});

Re: [visualization-api] Re: Challenges with the Select event or getSelection method?

Did you ever get this working Jamie? Being able to natively get the cell or column references would be useful, but as they are not, what I did was add a unique class name to each cell, then use an eventListener, then used the results of that to get the row and column numbers back out of the

[visualization-api] Re: Adding a second curve to a graph

I can't see anything wrong with it - but that doesn't mean much. Are you getting any console messages? (F12 in most browsers, Opera uses Ctrl + Shift + i) If you remove the viewport code do the graphs display? If it's something to do with that, perhaps enabling explorer in options -

  1   2   >