Chart Layout The next pages will demonstrate the Chart Layout Ribbon. The examples are based on a Column Chart. Here are the steps to create that Chart. 1. Try it: Enter the Data Please select a blank spreadsheet. Enter the Labels in Row 1. Cell A1: Department Cell B1: Salary   Enter the Data in Column A. Cell A2: Web Designer Cell A3: Training Cell A4: Sales   Enter the Numbers in Column B. Cell B2: 45,000 Cell B3: 50,000 Cell B4: 75,000 Format Row 1: Bold Format Column B: Accounting Calculate the SUM B5=SUM(B2:B4) Home->Number

Exam 77-882: Microsoft Excel 2010 Core 6. Presenting Data Visually 6.1. Create charts based on worksheet data