Graphs and Charts.

1. Enter the following data. (See image below)

Top Cheese Spread/Ball Brands, 2003

($ mil.) Share
Alouette 5.19 9.27
Kaukauna 4.65 8.31
Price 3.6 6.43
Wispride 2.78 4.97
Private label 7.35 13
Other 32.4 58.02
100

MarketShare Report 2005



2. Select Insert Menu. Choose Chart.
3. Make sure the Standard Types tab is selected. If not, click the Standard Types tab.
4. Under Chart Types select Pie.


5. Click Next.
6. Make sure the insertion point is blinking in the Data range text box.


7. On the worksheet, highlight cells A4 through A9.
8. Hold the CTRL key down and also highlight cells C4 through C9. Let go of the CTRL key.

9. Click Next.
10. Make sure the Title tab is selected. If not, click the Title tab.
11. In the Chart Title textbox, type Top Cheese Spread/Ball Brands 2003.


12. Click Next.
13. Make sure that As object in: Sheet1 is selected.




14. Click Finish







Notes are located at at http://excel.schtuff.com/excel_charts_doc

and

http://excel.schtuff.com/excel_graph_doc

No comments: