You are here

Home » Research » Tutorials

Tutorials

Dot and Columns Chart

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: tutorials, chart, dot and columns chart, how to
Download

This tutorial shows you how to create a chart with dots aligned over columns in Excel.

Global Education Data

Type: Tutorials
Author: EPDC
Year of Publishing: 2008
Keywords: UNESCO, World Bank, OECD
Download

How to Make Animated GIFs

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: Tutorials, Charts, Animated Charts, animated GIF, how to
Download

This tutorial explains the process of making animated GIFs. The tutorial expands on the process of building animated graphs in Excel (see the How to Make Animated Graphs tutorial) to create animated charts that can be used on web pages.

How to Make Animated Graphs

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: Tutorial, animated graphs, scatter plot, how to
Download

This tutorial walks you through the steps of creating a simple animated graph in Excel. The end product is an animated scatter plot (similar to Gapminder World), but the basic technique can be extended to other types of graphs.

Line and XY Combination Chart

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: Tutorials, Charts, Combination Chart, how to
Download

This tutorial discusses a technique for creating a line and XY combination chart in Excel. The technique is useful for adding a target or benchmark line to a chart. 

Showing Progress with High/Low Lines

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: Tutorials, Charts, High/Low Lines, how to
Download

This tutorial teaches you how to create a chart with high/low lines. These help display progress from one year to another. 

Stacked Area Chart with Historical and Projected Data

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: Tutorials, Charts, Stacked Area Chart, Historical Data, Projected Data, how to, Excel
Download

This tutorial reviews the process of making a stacked area chart in Excel with a visible division between historical and projected values. 

Turning Multiple Charts into a PDF or Word Document

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: Charts, Tutorials, PDF, Word, how to
Download

This tutorial reviews three different options (Photo Printing Wizard, Word, and IrfanView) for viewing multiple charts together.

Working with Human Capital Pyramids

Type: Tutorials
Author: EPDC
Year of Publishing: 2012
Keywords: Tutorials, Charts, Human Capital Pyramids, how to, bar charts
Download

This tutorial explains how to create human capital pyramids in Excel by combining two bar charts to create a final pyramid.