Customizing charts in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 9 videos | 31m 41s
- Includes Assessment
- Earns a Badge
- CPE
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
-
45sThis 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 6sCharts 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
-
3. Formatting a chart4m 38sOnce 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
-
4. Modifying chart elements3m 12sWith 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
-
5. Inserting and formatting a trendline4m 4sA 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
-
6. Customizing chart axes4m 20sChart 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
-
7. Combining two types of chart4m 24sIf 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
-
8. Creating Sparklines2m 53sIn 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
-
9. Customizing Sparklines3m 19sIn 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 4.5 of 435 users
(435)
