How to Make Assumption Charts in Excel

1. Click the 'Insert' tab and then click 'Header and Footer.' This inserts a header and footer into your document.
2. Type a name for your chart into the header. For example, type 'World Market Information.'
3. 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.
4. Click cell 'C1' and type a column header for column C. For this example, type 'Europe.'
5. 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.'
6. Click cell 'A2' and type a descriptive name for the row. In the interest rate example, you might type 'Headline inflation.'
7. Click cell 'A3' and type a descriptive name for the next row. For example, type 'Core Inflation.'
8. Continue entering row headers in column A, starting at cell 'A4' and working downward. In this example, type 'GDP' into cell 'A4.'
9. 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.