google charts

Recent posts

Nuts and Bolts: Embed Charts and Tables in WordPress and Core Publisher

After you get your chart or table into Google Drive and formatted the way you’d like to, follow these steps, kindly collected by data viz maven Emilie Ritter Saunders, to get it into your post:

Embedding Charts in WordPress

  1. Make your chart public to the web: Share —-> Change “public on the web”
  2. Publish your table: Click the arrow dropdown (upper right corner of the chart) —-> Select a chart1publish format “Image.”
  3. Copy that “Image” code and paste it into the HTML side of your WordPress editor.

Embedding Tables in WordPress

  1. Make your table public to the web: Share —-> Change “public on the web”
  2. Publish your table: File —-> Publish to the web —-> Click Publish or Republish Now
  3. Copy the URL.
  4. Paste the URL into the spreadsheet function in WordPress, “Google Spreadsheet Key.” Continue reading →
Filed under: Build, Charts, Core Publisher, Data Viz, google charts, Google Fusion Tables, graphs

Advanced Google Chart Tools

Did you have fun with the updated Google Chart Tools? Well, that’s only the tip of the iceberg of fun and possibility. Google has created a chart gallery with different kinds of prototypes for you to play with.

I will explain to you how we could use some of those prototypes for better data storytelling. You can also consider this as your first step into the information design world, thinking about grouping and presenting information. Continue reading →

Filed under: Master, advanced, Charts, Data Viz, google charts, tree map

Google Charts Gets a Style Update

Here’s How to Take Advantage of It In Your Blogs

Our designer Danny DeBelius has introduced us to a data visualization tool called Google Image Charts. It’s pretty handy when you need some simple charts to help tell your stories. Now, guess what? Google has updated that tool and make the experience even better.

The main difference is that you don’t need to go to a Image Charts Editor page, but you can finish the process in your Google spreadsheet.

Connect to your data in real time

Let me explain this tool by using an example. I have a spreadsheet with data about Idaho legislators compiled by Emilie Ritter Saunders. Now try this: if you go to the spreadsheet, change some numbers in the education worksheet and refresh this post, you will see the numbers also changed here in the image below.

Isn’t it amazing? The updated Google charts tool connect your chart to your data in real time, making it convenient to change numbers or styles or add data to your posts as it becomes available.

Easy to use

This tool is also easy to use. We all have some experience using Excel to produce simple charts and graphics. The rules are similar here: Continue reading →

Filed under: Build, Data Viz, google charts