Back to COSI 118 -Home

First Quarter Sales

Note: The following example is copied from New Horizons.
Products January February March Total Percent
Pentium 133 2000 1950 2175    
Pentium 100 2195 1995 2095    
Pentium 90 2150 2285 2165    
Monitors 2245 2145 2050    
Total          
Average          

1. Create the above worksheet.
   (Note:  Give formulas for Total, Average, and Percent.)

2. Select the following area:
 
Products January February March
Pentium 133 2000 1950 2175
Pentium 100 2195 1995 2095
Pentium 90 2150 2285 2165
Monitors 2245 2145 2050

3. Click the Chart Wizard button.
4. Click and hold the button Press and hold to view sample.
5. Release the mouse button.
6. Click Next.
7. Select Rows after Series in:
8. Click the Series tab.
9. Select Pentium 100 under Series.
10. Click Next >.
14. Click the Chart title: field, and type in title.
15. Click the Legend tab.
16. Click Bottom under Placement.
17. Click Next >.
18. Make sure As object in: is selected under Place chart:
19. Click Finish.
20. Click and hold a blank area within the chart then drag the chart to other place.

Note: You can try 3-D chart by yourself.
See the graph.