Exercise #4 Creating a Chart from a Worksheet
In this exercise you will learn how to create and format a chart for information in a worksheet.
A. Open the file from Exercise 3. 1. Open YourName Summer Reading file. 2. Choose, File/Save As to save this file as YourName Summer Reading Chart. B. Use the Chart Wizard to create a Pie Chart. 1. Click on the Chart Wizard icon in the toolbar. 2. Click on the Standard Types tab, choose Pie. Click Next. 3. The Source Data window will open. Click on the icon to the right in the Data Range box. a. Select the cell range to chart (A1 thru E 5). Do not include totals. b. Click on the icon to the right in the Data Range box again. c. Click on the radio button labeled Columns. 4. Go to the Series tab. a. Under Series in the middle of the window, remove all column titles but Books Read and %Books Read Per Group. (This is the information you want to illustrate with the chart. ) b. In the Series box, highlight titles to remove, click the Remove button. Click Next. 5. Click on the Titles tab. In the Chart Title box, enter the chart name. 6. Click on the Legend tab. Be sure Show Legend is selected. a. Choose a placement location for the legend. 7. Click on the Data Labels tab and choose Percentage. Click in the box next to Legend Key and Show leader lines. Click Next. 8. Click in the radio button As object in. 9. Click Finish.
C. Change the chart to a different chart type.
1. Click in the white area of the chart to select it. 2. Click on Chart on the menu bar. Choose Chart Type. 3. Choose a different type of chart to display this information. Click OK. How did this chart type work with the data?______________________ D. Change the chart background. 1. Select the chart. Right click in the chart. Choose Format Chart Area. 2. Click on the Patterns type. 3. Click on Fill Effects. Choose Gradient and choose one of the example styles and click OK twice to close both dialog boxes. E. Save your work.
Putting Excel to Work in the Library Fall 2004 - This material has been created by Sandy Lamoureux for the Infopeople Project [infopeople.org], supported by the U.S. Institute of Museum and Library Services under the provisions of the Library Services and Technology Act, administered in California by the State Librarian. Any use of this material should credit the author and funding source.