Tag Info

Hot answers tagged

5

There are a number of different JavaScript based toolkits, in addition to the Google Visualization and Charts APIs. I find Protovis (which SVG based) to be an excellent middle-ground between toolkits that are too low-level that they're laborous and painful to get going, and too high-level that every chart looks too similar. The JIT is a Canvas-based ...


4

You could also use Google Chart Tools.


4

Maybe this is what you need? What is the Google Chart API? The Google Chart API lets you dynamically generate charts with a URL string. You can embed these charts on your web page, or download the image for local or offline use.


4

You need to add a helper column within the QUERY formula, like so: =QUERY( {A1:B6, A1:A6}, "SELECT Col1, COUNT(Col3) WHERE Col2 = 'SubCatA' GROUP BY Col1 LABEL COUNT(Col3) ''" ) Adding another QUERY formula will help to remove the helper column: =QUERY( QUERY( {A1:B6, A1:A6}, "SELECT Col1, COUNT(Col3) WHERE Col2 = 'SubCatA' GROUP BY ...


3

You can reproduce the required table using a formula (this will only work on the newest version of Sheets): =QUERY({A:A,A:A},"select Col1, count(Col2) where Col1 is not null group by Col1 label Col1 'Date', count(Col2) 'Number'",0) And then reference that output for your graph. If you are on the old version: =ArrayFormula(QUERY(IF({1,1},A:A),"select ...


3

I have created a solution for myself via Chrome Extension. Chrome Extension This is my first chrome extension, and this is not intended to publicize said extension. I may create Firefox and Safari versions at a later date, but as this is currently for my personal use and I use Chrome here it is. I will also include the code here for anyone interested in ...


2

In terms of a "web app that comes closest to the sketch and or description", my first thought was Google Squared - but alas, it no longer exists (I thought it was an amazing innovation). But here's something to try: http://www.wolframalpha.com. Enter a search term such as mammals or presidents.


2

IBM Many Eyes might work for this. Many Eyes allows pure data in either text or table format to be uploaded and processed into multiple visualization formats. Hope this helps.


2

Without a query: =unique(filter(A1:A6, B1:B6="SubCatA"))


1

Put a column labels at the top of the column Put in a helper column next to it, and in every cell say =if(ISBLANK(A1),0,1) Then choose Data > Pivot Table Report, and enter the data range as A:B This will create a new tab with the data series you want. You can then create a graph from this. See an example of this approach here: ...


1

You can upload data from a speadsheet to Google Fusion Tables and there's examples to get started. Also try searching the google group for specific tips on creating a heat map.


1

I was about to suggest Swivel, but they went out of business. However, that article led me to Many Eyes. It looks like it's a product of IBM research that may fit your needs: On Many Eyes you can: View and discuss visualizations View and discuss data sets Create visualizations from existing data sets If you register, you can ...



Only top voted, non community-wiki answers of a minimum length are eligible