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
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.