Customizing charts in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 9 videos | 31m 41s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 250 users Rating 4.5 of 250 users (250)
You can analyze and present your Excel 365 data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to customize individual chart elements, including customizing chart axes, moving or combining two types of chart, and customizing the chart's titles, labels, and axes. You will also explore how to insert and customize trendlines that can be used for data ranges, movements, or correlations; as well as how to add and modify Sparklines, which are at-a-glance visualizations. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this customizing charts in excel 365 course
    Customize charts in excel 365
    Format a chart in excel 365
    Modify chart elements
    Insert and format a trendline in excel 365
  • Customize chart axes in excel 365
    Combine two types of chart in excel 365
    Create sparklines in excel 365
    Customize sparklines in excel 365

IN THIS COURSE

  • 45s
    This video outlines the key content covered in this Microsoft 365: Customizing charts in Excel 365 course, including how to modify chart elements, combine two chart types, and how to create and customize Sparklines in Excel 365. FREE ACCESS
  • 4m 6s
    Charts are useful visual representations of an Excel 365 worksheet that make the data easier to analyze and interpret. Once inserted, you can customize individual elements of a chart. In this video, you will explore how to move a chart and customize its title, labels, and axes in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 5.1.2 Create chart sheets. As well as MOS MO-200 / Excel Associate Certification exam objective: 5.2.3 Add and modify chart elements. FREE ACCESS
  • Locked
    3.  Formatting a chart
    4m 38s
    Once you have created your chart in Excel 365, you can begin to change its appearance. Updating the style can make the data easier to interpret or emphasize. In this video, you will explore how to change the color of an element, adjust the font styles of any text item, and change the overall visual style of your chart in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 5.2.3 Add and modify chart elements. As well as MOS MO-200 / Excel Associate Certification exam objectives: 5.3.1 Apply chart layouts and 5.3.2 Apply chart styles. FREE ACCESS
  • Locked
    4.  Modifying chart elements
    3m 12s
    With Excel 365, it's possible to modify different elements of a chart. In this video, you'll see how to add data series to charts, switch between rows and columns and add alternative text to charts. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 5.2.1 Add data series to charts. As well as MOS MO-200 / Excel Associate Certification exam objectives: 5.2.2 Switch between rows and columns in source data and 5.3.3 Add alternative text to charts for accessibility. FREE ACCESS
  • Locked
    5.  Inserting and formatting a trendline
    4m 4s
    A trendline is a straight or curved line in a chart that shows the general pattern of data. In Excel 365, the addition of trendlines can enhance the appearance of your charts and assist you in data analysis. In this video, you will discover how to add a trendline to your Excel 365 chart, as well as format it. FREE ACCESS
  • Locked
    6.  Customizing chart axes
    4m 20s
    Chart axes quantify the information you're presenting in Excel 365. You can adjust the measurements, move the maximum and minimum values, and change where the two axes cross in the chart. In this video, you will explore how to modify the chart axis in Excel 365. FREE ACCESS
  • Locked
    7.  Combining two types of chart
    4m 24s
    If you have multiple types of data in your Excel 365 table, then you may experience problems with your chart's scale and display settings. In Excel 365, you can use the combo chart to create a graphic that combines multiple data types. You can even add a secondary axis. In this video, you will explore how to combine two types of charts in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 4.1.1 Create and modify dual-axis charts. FREE ACCESS
  • Locked
    8.  Creating Sparklines
    2m 53s
    In Excel 365, you can insert miniature charts—called sparklines—that track the overall trend of a data series. These are very beneficial in interpreting data that follows a trend or pattern. In this video, you will learn how to create line, column, and win/loss Sparklines, as well as remove Sparklines in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.4.1 Insert Sparklines. FREE ACCESS
  • Locked
    9.  Customizing Sparklines
    3m 19s
    In Excel 365, Sparklines can be formatted to highlight certain pieces of data. You can change the color scheme, activate and deactivate different data points, and even visualize negative values in your trends. In this video, you will learn how to customize Sparklines in Excel 365. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.5 of 99 users Rating 4.5 of 99 users (99)
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 378 users Rating 4.6 of 378 users (378)
Rating 4.5 of 1670 users Rating 4.5 of 1670 users (1670)
Rating 4.4 of 201 users Rating 4.4 of 201 users (201)