create excel chart

When displaying your work in a presentation, it can often be difficult to visualize your data for the benefit of your audience. If you are working with numeric data, your data can be displayed in a number of different charts but there are so many to choose from.

Chart Chooser from Juice Analytics is an innovative tool that lets you create Excel and Powerpoint charts and choose what characteristics you wish to highlight in your data; Comparison, Distribution, Composition, Trend, Relationship and/or Table, and it will filter the selections highlighting the possible charts for your needs.

create powerpoint charts

Once you have decided on your selection, Chart Chooser will display options to download templates for Excel and Powerpoint. The downloaded files will have random data filled for you to get an idea of how the data is presented and where you will be able to enter your own figures.

chart chooser

The good news about this service is that Juice Analytics doesn't seem to be stopping with the current selection of graphs available on the site. Users are encouraged to suggest different charts to be added to their website and even design bespoke versions for organisations. Juice Analytics have also endeavoured to make all their charts Tufte-compliant (clean and minimal) whilst remaining visually aesthetic.

Juice Analytics also operates an analytics blog that focuses on free tools and open source code. Here, you are able to find a wealth of information on how the Juice Analytics team tackle different projects, including this project inspired by the New York Times.

One tool that the team recently released was Concentrate, a search analytics tool for SEO and paid search professionals who wanted to make sense of search keyword data. Concentrate works by connecting to your Google Analytics account and helps to visualize keyword relationships to see connections and performance of common word combinations. All data collated by Concentrate is automatically formatted and information such as categorized search phrases and pattern groups can be downloaded to CSV format for off site analysis.

Juice Analytics is a great source of Excel and Powerpoint information as well as providing open source code, most of which are licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License. If you need to impress the board, your boss or your peers at your next meeting, a visit to these guys, even just for the Chart Chooser, should be your first stop.

Do you know of any other sites that offer templates like these? If so, let us know of your recommendations in the comments!