Data Visualization Toolkit: Charts Resources & Tools

Charts Resources

Data Visualization Checklist. This checklist provides detailed guidance on text, arrangement, color, and lines. It is useful to refer to when developing a chart of any type.

Charts Tools

Microsoft Excel

Microsoft Excel is one of the most widely used platforms for analyzing and charting data. It’s possible to generate the most common chart types from the raw data in a spreadsheet. Although Excel is somewhat limited in default options, skilled users can create a large variety of effective data visualizations. Also, Microsoft PowerPoint has a limited set of charting options that are based on the Excel platform. You can import an Excel chart into PowerPoint by copying and pasting it in as an image.

Read More +

Datawrapper

Datawrapper is an online automatic chart-maker. You can upload or copy-paste your own data and Datawrapper will automatically generate and allow you to customize various bar charts, dot plots, circle charts, line charts, and even maps. Figure 12, for example, shows a split bar chart created using Datawrapper. Charts can then be downloaded as images or embedded in websites.

Read More +

Advanced Statistical Software

Advanced statistical software such as SAS, SPSS, and Stata are used to manage and analyze large, complex data sets. These programs also have the capability to graph analyses of data using syntax to write programming code or graphical user interfaces to select commands. Advantages of using these programs to create charts are that you do not have to transfer analytic output needed for the chart to another program (like Excel), and you can analyze datasets quickly to get the data needed for charts. Disadvantages are the cost of the programs and the skill needed to use them effectively. This section focuses specifically on SAS.

Read More +

Tableau Public

Tableau is a dynamic tool with many capabilities. Drag and drop data sets and variables into interactive data dashboards, and export your visualizations online or in graphic form. Tableau Public is the free version, which has advanced capabilities but requires that all data be public.

Read More +