Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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: • Createcharts • 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 areused to make comparisons about groups of data • This chart compares Senior, Junior, and Sophomore attendance rates at assemblies over a period of four months.
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
Line Chart • The Line Chart is used to indicate trends in data • Examine the Sales Trends chart below
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
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 chartsin Excel 2010.