Have you ever had a set of data and not been sure of the most effective (and appropriate) way to visualize it in the form of a chart or graph? The folks over at Juice Analytics have put together a page that — should be able to — answer just about all your questions or problems. The image to the right is a screenshot of the page to which I’m referring. If you click on it, you’ll be taken to the URL of the image and then you can zoom in to see just what I’m talking about when I say that this should be able to answer, “Just about all your questions or problems,” when it comes to picking a chart.
When I first had this site bookmarked, I knew that this was going to be good when it came to picking charts for Microsoft Excel. After revisiting it to write this post, I noticed that it will also be useful in picking charts for Microsoft Powerpoint! How is it useful for these two programs?
Well, when you click-through to the site, you’ll see a number of charts. If you hover over one of the charts, it will show you the kinds of data that are appropriate for that chart. That sounds simple enough and would be useful (if that were all), but they went one step beyond useful — you can also download the template! And not only are there templates for Excel, there are templates for Powerpoint, too! (Near the top of the screen, you can sort by Excel or by Powerpoint. You can also sort by different types of data, too, rather than hovering over each and every chart.)
I most certainly have bookmarked this page and will be returning in the future. I hope you can find use out of it, too!
Jeremiah Stanghini 