Charts for Google Sheets

It's fairly well known that I'm not a visual thinker. Any visuals I use are either (1) someone else's doing, (2) created by a very effective tool. In the latter category, I recently discovered Charts for Google Sheets. It all starts out easily enough, with Insert Chart. If you insert the chart off to the right of your data, and update the range ...

It's fairly well known that I'm not a visual thinker. Any visuals I use are either (1) someone else's doing, (2) created by a very effective tool.

In the latter category, I recently discovered Charts for Google Sheets. It all starts out easily enough, with Insert Chart. If you insert the chart off to the right of your data, and update the range formula, you can even click through example charts, and see how Google Spreadsheet maps the data for you.

Though, the data I had originally input just was not setup in a way that worked well with Google Sheets. The application does a great job of providing suggestions, but I was just too dim to get it right.

Examples to the Rescue!

Finally, I stumbled upon the "Examples of New Charts in Spreadsheets". I quickly clicked "Use this template", and used "Copy to" to get the example I wanted into my working spreadsheet. Moments later, I had transferred my data into the example, and, , I had exactly the chart I wanted.

But, wait, there's more

Aside from embedding charts in your Google spreadsheets, you can use Google Charts to embed charts in your web pages, using JavaScript libraries. If you're a website developer, be sure to checkout Google Charts.

While Google Charts is nothing new, it's a great tool to have in your belt the next time you need to work up a quick visual.

 

Source: www.nimbleams.com