From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create and modify dual-axis and combo charts
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Create and modify dual-axis and combo charts
- [Instructor] A lot of times when we work with our data, we have two distinct data types. For instance you may have data that shows your total sales, and have data that shows units sold and you want to chart those in one chart. Well that's where your dual access charts and your combo charts come into play. After watching this video, you'll know how to create a secondary axis on an existing chart, and then I'll also show you how if you know you want a dual axis chart ahead of time you can just use the combo chart function. Let's jump into our dual axis charts workbook, and we'll begin by selecting our data, item, sales, and units sold. On our Insert tab we have a chart group, and of course we have recommended charts, but we're going to go ahead and click on the more button to get into insert chart. Skip over to all charts. When you're creating a dual axis chart, you usually just start with a 2D clustered column…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Create and modify dual-axis and combo charts2m 47s
-
(Locked)
Create and modify box and whisker and funnel charts5m 55s
-
(Locked)
Create and modify histogram and map charts6m 27s
-
(Locked)
Create and modify sunburst and waterfall charts6m 39s
-
(Locked)
Create and modify PivotTables7m 44s
-
(Locked)
Create and modify PivotCharts6m 5s
-
(Locked)
Challenge: Manage advanced charts and tables28s
-
(Locked)
Solution: Manage advanced charts and tables5m 40s
-
(Locked)
-
-