The Consumer Price Index and Inflation - Make the Graph

Figure 4. The first step in making a graph from your current table.

1. In your table select Columns B and C. Click the Chart icon (circled in Figure 4).
   
   
2. Use the Chart Wizard:
   

• Step 1. Click XY (Scatter). For Chart Subtype, click the smooth curves, highlighted in Figure 4. Click Next.
  
  
• Step 2. Click Next again.
  
  
• Step 3. Insert a title for the graph and for each axis. For Gridlines, choose Major gridlines for each axis (see Figure 5). Click Next.

Figure 5. Choosing gridlines.

• Step 4. Request the chart As New Sheet. Click Finish. Figure 6 shows the complete graph.

Figure 6. The finished graph.