Skip to Main Content
Office 2013 Digital Classroom
book

Office 2013 Digital Classroom

by Walter Holland, AGI Creative Team
August 2013
Beginner content levelBeginner
672 pages
14h 31m
English
Wiley
Content preview from Office 2013 Digital Classroom

Excel Lesson 5: Working with Charts

ex05.psd

In this lesson, you will learn how to create charts from your worksheet data. You will learn how to use recommended chart types, customize chart elements, and change formatting options. You will also learn how to spot trends in your data with Sparkline charts. Finally, you’ll learn how to print your worksheet charts.

What you’ll learn in this lesson:

  • Creating a chart
  • Using chart recommendations
  • Updating data in a chart
  • Enhancing chart options
  • Printing a chart

Starting up

You will work with files from the Excel05lessons folder. Make sure you have loaded the OfficeLessons folder onto your hard drive from www.digitalclassroombooks.com/Office2013. If you need further instructions, see “Loading lesson files” in the Starting up section of this book.

Understanding chart types

Excel offers a number of different chart types. From bar graphs and pie charts to scatter plots and area charts, Excel provides a chart type for the data you want to present. The new Recommended Charts feature helps to remove some of the guesswork by offering a number of chart types based on your selected data. You can also change the chart from one type to another once it is complete. The following table lists the 12 chart types that Excel offers.

Chart types

Type

Icon

Description

Area

Shows the relative importance of values over time. An ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Word 2007 Step by Step

Microsoft® Office Word 2007 Step by Step

Joyce Cox and Joan Lambert
Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg

Publisher Resources

ISBN: 9781118571613Purchase bookOther