Loading...

PRDV252: Intermediate Excel

Unit 6: Presenting Data with Charts   This unit will introduce charts, which are a very important feature in Excel®. Charts help people to visual the data. Sometimes too much information or lists of numbers cannot be compared or processed by our brains efficiently. Charts help us humans to organize and visualize information so we can grasp the concepts quicker. There are many different types of charts. Which chart type to use will depend on the information you are charting. For example, if you want to compare sales totals from each branch office of a company, and that company had five or six branches, then a pie chart would work perfectly. If the company had 15 or 20 branches, that would be too many pie pieces, so a column chart could be used. The reading will give you some good examples of this concept. You will need to have the newer versions of Excel® to use the file that accompanies this chapter. Charting and Chart Formatting changed drastically from Excel® 2007 onward. If you have an older version, you can still chart but you will need to use Help to learn about the features in your version of Excel®.

Unit 6 Time Advisory
Completing this unit should take you approximately 3 hours.

☐    Subunit 6.1: 1.5 hours

☐    Subunit 6.2: 1.5 hours

Unit6 Learning Outcomes
Upon successful completion of this unit, you will be able to: - construct a line, column, pie, and stacked column chart; - create separate chart sheets for an embedded chart in a worksheet; - create charts to show comparison and frequency distribution; - apply formatting changes and titles to the X and Y axes of a chart; - apply formatting changes to all areas of a chart including the title, plot, and data series;

6.1 Choosing a Chart Type   - Reading: How to Use Microsoft Excel®: “Section 4.1” Link: How to Use Microsoft Excel®: Section 4.1 (PDF)
 
Instructions: Go to Chapter 4, which starts on page 308. Read through the first page then proceed to Section 4.1: Choosing a Chart Type, which starts on page 309. If you have a recent version of Excel® (2007 or newer), you can click on the link in the resource box below to open up the starting document that goes with this chapter, Excel® Text Chapter 4. You can use this file as you work through the chapter.
 
Completing these assignments should take approximately 1 hour and 30 minutes.
 
Terms of Use: The textbook used in the link above is released under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License without attribution as requested by the work’s original creator or licensee.

  • Activity: The Saylor Foundation’s“Excel® Text Chapter 4” Link: The Saylor Foundation’s “Excel® Text Chapter 4”
     
    Instructions: This file is in the newest version of Excel® and uses the file extension .xlsx. You will need to have Excel® 2007 or newer to open the file. The charting feature changed quite a lot with the newer versions of Excel®. The book will show many of these new features on three ribbons that go along with charting: Design, Layout, and Formatting.

    Completing this activity should take approximately 1 hour.

6.2 Formatting Charts   - Reading: How to Use Microsoft Excel®: “Section 4.2” Link: How to Use Microsoft Excel®: Section 4.2 (PDF)
 
Instructions: Go to Chapter 4, Section 4.2: Formatting Charts, which starts on page 342. Continue to use the file you started in Subunit 6.1 above (Excel® Text Chapter 4). There is a lot of detail work in formatting charts. This subunit shows only a small portion of the many, many ways a chart can be formatted. I encourage you to explore as many formatting features on the three chart toolbars as you can. Use your Help feature to learn more about each feature if something gets confusing.
 
Completing this assignment should take approximately 1 hour and 30 minutes.
 
Terms of Use: The textbook used in the link above is released under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License without attribution as requested by the work’s original creator or licensee.