Junar lets you create graphs to give life to your Data

Some Junar news for you all... a lot of users asked us for graphs, and here they are. We tweeted about this a few days ago but below is a more detailed description on how to make your Dashboards look even better with good graphs and visualizations.

Step #1 - Go to one of your dashboards and pick one of those Data Streams that you can use to tell a story from the Data. For this example, I'm using my VC investments Dashboard and my latest 10 Emergence Capital investments Data Stream.

3_db_wo_graphs_with_arrows

 

Step #2 - In the Dashboard View, go to the Data Stream you want to use to create a graph, click first on Actions and then on 

5_ds_w_actions_and_create_chart_signaled

Step #3 - Follow the steps to create the graph you want. Start by selecting the figures to be displayed and then select chart type, and add some clarifications and labels

9_creating_the_chart

Step #4 - Organize and enjoy your new Dashboard brought to life !

92_db_w_graphs

... and if you enjoyed doing this even half as much as Mati enjoyed coding this for you, please share your cool graphed Dashboard with the world !

Please contact us if you have any question,

Junar Team 

Publish Data from Google Spreadsheet

A week ago we announced how to bring Junar Data Streams into Google Spreadsheets.

Google insisted on returning the favor so it is possible now to publish Data Streams from pieces of Tables in your Google Spreadsheets !

Say you are passionate about Venture Capital, you have extracted some interesting information from LinkSV, and you now want to publish this data to the world. Here´s what you do:

#1 - You create the table you are interested in publishing and to honor the sources you write them below

1_table_w_source

#2 - You ensure that there are no protected areas in the document. This means that the column and row freeze bars are in the top left corner as you can see in the image above.

#3 - You need to publish the sheet in which the table is located. Ensure that you (i) publish as a webpage, (ii) select ONLY the one sheet.

2_publishing

#4 - You can get the link of this public sheet

3_link_to_collect

#5 - And now you go to Junar to "collect a new Data Stream" as you already know, or you just use our bookmarklet if you are a Junar Ninja

4_paste_link_in_junar

And in case you want to check out this Data Stream, just go visit "Last 50 VC investments distribution"

Untitled

 

Cheers, 

The Junar team

Insert live Junar Data in Google Docs

A new feature released by Junar, here it is: Insert live data streams into your Google Spreadsheets.

Very simple

1. Find the Data Stream you like (in this example a LinkSV sourced Data Stream on investments in Silicon Valley)

2. Click on ´Actions´ and then on ´Google Spreadsheets´ to get the ´code´

   -> =ImportHtml("http://www.junar.com/datastreams/html/34755/top-10-largest-vc-rounds-in-2011-linksv-investments-summary/" ; "table" ; 1)

3. Then, just go to your google Doc and insert the code in a cell

Slide2

4. The Data Stream coming from a site in the web (or from a computer of a Junar Data Publisher) will be updated by Junar in your google doc

Slide4

For sharing Spreadsheets you certainly use Google Docs... Start embedding live data from the web that you find in the Junar growing catalog of pre-curated data. Let us know what you think (support@junar.com).