1 / 11

Working with Charts and Graphics

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.

radley
Download Presentation

Working with Charts and Graphics

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


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

  2. 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.

  3. 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

  4. 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?

  5. 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.

  6. 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.

  7. 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

  8. 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

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

  10. 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

  11. 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.

More Related