How to Make Assumption Charts in Excel
An assumption chart is a type of chart that attempts to predict future behavior, based on a series or rules or assumptions. For example, you can build a chart with interest rates for various countries around the world which will give you a snapshot with which to make investment decisions. Assumptions charts are also used by various government agencies like the U.S. Department of Housing and Urban Development. Microsoft Excel is the ideal software to create an assumption chart.
Things You'll Need
- Excel 2007 or Excel 2010
Click the "Insert" tab and then click "Header and Footer." This inserts a header and footer into your document.
Type a name for your chart into the header. For example, type "World Market Information."
Click cell "B1" and type a heading for column B. For example, you might type "United States" if you want an assumption chart for world interest rates.
Click cell "C1" and type a column header for column C. For this example, type "Europe."
Continue entering column titles in row 1, beginning at cell "D1" until you have entered all of your column titles. In this example, type "U.K." into cell "D1" and then type "Japan" into cell "E1."
Click cell "A2" and type a descriptive name for the row. In the interest rate example, you might type "Headline inflation."
Click cell "A3" and type a descriptive name for the next row. For example, type "Core Inflation."
Continue entering row headers in column A, starting at cell "A4" and working downward. In this example, type "GDP" into cell "A4."
Fill in the information in the rows and columns of your chart. For example, click cell "B2" and type the headline inflation for the United States.
Tips & Warnings
- Format cells by right-clicking the cell and then clicking "Format cells." For example, in the world interest rates assumption chart you might want to format cells as percentages. Click the "Number" tab and then click "Percentage." Click "OK" to close the window and format the cells.