This site is designed to assist policy and other decision makers to create useful graphs in Microsoft® Excel®. The first section provides a brief discussion of the history of graphs, their use in decision making and the difference between good and bad graphs. The second section gives step by step instructions for creating a range of basic graphs in Excel.
Instructions for creating seven different types of graphs in Excel are given below. In each part is a video showing that type of graph being created. A downloadable spreadsheet of the data used in this video and a printable file of written instructions are also provided so that the user can create for themselves the same graph shown in the video.
New Zealand data has been used in all graphs in the Introductions to each graph type, and United Kingdom data in the Videos and Instructions sections.
Measuring Price Change | |
Comparing Populations |