MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide

Chapter 5Managing Charts

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Manage charts
  • Create charts
    • Create charts
    • Create chart sheets
  • Modify charts
    • Add data series to charts
    • Switch between rows and columns in source data
    • Add and modify chart elements
  • Format charts
    • Apply chart layouts
    • Apply chart styles
    • Add alternative text to charts for accessibility

A chart is an effective way to grasp data in a worksheet visually. You may remember how you had to create charts in math classes in school, where you learned the relationship between data and a graph. It should come as no surprise that Excel has charts built in since Excel deals a lot with math.

I start by showing you how to create charts, both in the same worksheet and in a separate ...