Working with Charts and Graphics CREATING CHARTS Lesson

Working with Charts and Graphics CREATING CHARTS Lesson 6 - Microsoft Excel 2010

Learning Goal The goal of this lesson is for students to successfully create charts to present data in Microsoft Excel 2010. The student will learn to apply, create, and modify various types of charts.

Learning Objectives �On completion of this lesson, students will be able to do the following: �Create charts �Move, resize, and delete charts �Modify chart titles �Move and format chart elements �Change chart types and organize source data �Update data and format the axes �Add gridlines and arrows �Using illustrations �Preview and print charts

Lesson Introduction �Microsoft Excel enables users to create pictorial representations of data using charts. �What type of data might be appropriate for a chart? �Which type of chart is best suited to represent that data?

Creating Charts �There are six common charts used in business. �Column Chart �Bar Chart - most common charts �Pie Chart �Line Chart �XY Scatter �Exploded Pie Chart �It is important to understand how and when each chart is used to communicate information.

Column Chart � Column charts are used to make comparisons about groups of data � This chart compares Senior, Junior, and Sophomore attendance rates at assemblies over a period of four months.

Review The Previous Slide, To Answer The Following Questions �Which group attends assemblies most consistently? �The sophomores have the most consistent attendance as evidenced by the gold columns. �Which group attends the assemblies most inconsistently? �The seniors. Their attendance increases in January and February, shows a dramatic increase in March, and declines by more than half in April.

Stacked Bar Chart �The stacked bar chart is used to represent the contribution of individual items to a whole �Each bar is divided into two or more parts �The length of the stacked bar represents a total

Pie Chart and Exploded Pie � The Pie chart is used to represent only one series of data �Examples: � Percent (%) of each expenditure in a budget � Percent of each investment type in a portfolio � Answers the question, “What is the percentage of each part to the whole? ” � The Exploded Pie chart is used to emphasize one or more portions of the data

Review The Previous Slide, To Answer The Following Questions �Which item contributed the most percentage to East Region’s budget? �Desktops �Which Genre contributed the most percentage to the Music sales? �Rock

Line Chart � The Line Chart is used to indicate trends in data � Examine the Sales Trends chart below

Review The Previous Slide, To Answer The Following Questions • Which department showed the most growth? • The Clothing Department • Which department showed a steady increase in sales? • The Music Department • Which department showed a decline in sales? • The Shoe Department

XY Scatter Chart • The XY Scatter chart is used to indicate a correlation between two or more sets of data • A business example of an XY Chart is one that represents the effect (if any) of caffeine on worker productivity

Review The Previous Slide, To Answer The Following Questions �What affect did the wait time in the principal’s office have on pulse rate? �The pulse rate increased as the wait time for the principal became longer. �What affect did the wait time in the doctor’s office have on pulse rate? �The pulse rate decreased and became steady as the wait time for the doctor’s office became longer.

Selecting Data for a Chart • • When creating a chart, select only the data you wish to display. Totals are not usually used Click the insert tab to select the appropriate chart type to display your data There are two ways to display a chart As a separate chart sheet Embedded in the worksheet with the data • • Go to this tutorial for creating charts in Excel 2010.

Test Your Knowledge Answer Key: 1. TRUE 2. FALSE Charts may be resized at any time. 3. FALSE The column chart or pie chart. 4. FALSE Chart sheet are entire sheets that contain only chart information. 5. TRUE True/False 1. The chart area is a rectangular area that contains the charts and other chart elements. 2. Charts may not be resized once they are created. 3. The line chart is considered the most commonly used chart type. 4. Chart pages are entire sheets that contain only chart information. 5. Data labels are used in charts to associate data values with the charted information.

Test Your Knowledge Answer Key: 1. B (Series Labels) D (Chart) D (Row) 2. 3. 4. B 5. (Embedded Chart) A (Legend) Multiple Choice 1. Which of the following is not a component of a data series? a. Series name b. Series labels d. Category values 2. A _____ is a graphical representation of a set of data. a. picture b. label diagram 3. c. Series values c. chart Which of the following is not an Excel Chart type? a. Column b. Line c. Row 4. d. Pie An _____ is a chart this is display on the same worksheet as the source data. a. Included Chart b. Employed Chart c. Inserted Chart d. Embedded Chart 5. The _____ is an area that labels the data used in a chart. a. Legend b.

Vocabulary Words Please add the following vocabulary terms to your list of terms and definitions. • Chart • Pie Chart • Bar Chart • Column Chart • Line Chart • XY Scatter • Exploded Pie Chart

Practice What You Have Learned Complete the following assignments. When complete, save and submit. Assignments Excel Lesson 6 – Exercise 1 Excel Lesson 6 – Project 1