ECO 550

Instructions

Graphing With Excel 2003

1. Enter the data for Price, Quantity Demanded, and Quantity Supplied in three columns anywhere in the spreadsheet.

2. Click on the Chart Wizard icon

3. Select XY (Scatter) and select a chart subtype with lines.  Click Next.

4. Click on Series tab, then click on add.  You will see in the series box Series 1 added.  Type the name of the series - Demand.  Then in X values box, enter the cell range for Quantity Demanded.  In Y value box, enter the cell range for Price.  You will see your Demand curve appear on the graph.  Next, add another series for Supply.  Name it Supply.  In X values box enter the cell range for Quantity Supplied.  In Y values box, enter the cell range for Price.  You will see your Supply curve appear on the graph.  Click next.

5. Enter your chart title, for example, “The Market for Pizza”.  In the value (X) axis box, type Quantity; in the value (Y) axis box, type Price. 

6. Click Next and then Finish.

Graphing With Excel 2007

1. Enter the data for price, quantity demanded, and quantity supplied in three columns anywhere in the spreadsheet.

2. Click on Insert tab

3. From the Chart Types select XY (Scatter) and then Scatter with Straight Lines .  Click OK.

4. Click the Select Data icon. Under Legend Entries (Series) click on add.  You will see in the series box Series 1 added.  Type the name of the series - Demand.  Then in Series X values box , enter the cell range for quantity demanded (x values are measured on the horizontal axis).  In Series Y value box , enter the cell range for price (y values are measured on the vertical axis).  Click OK. You will see the demand curve appear on the graph.  Next, add another series for Supply.  Name it Supply.  In Series X values box enter the cell range for quantity supplied.  In Series Y value box , enter the cell range for price.  You will see the Supply curve appear on the graph.  Click OK.

5. When you click on inside the graph, you may select the chart layout, enter the chart title, and label the horizontal and vertical axis. For example, you can enter the title “The Market for Pizza”.  In the value (X) axis box, type Quantity; in the value (Y) axis box, type Price.