From the course: Excel: Charts in Depth
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Combination charts
- [Instructor] This worksheet is called combo chart, and that's actually the name of a chart type in Excel that you might not be familiar with. As we look at the data on this chart, column A shows the month, we see the miles driven, maybe this represents the fleet of vehicles that we have. This is how many miles were driven each month, and we've calculated the miles per gallon for all of our vehicles. We'd like to show both of these numbers in the same chart, and they're wildly different in magnitude. These are all below 25, these are in the tens of thousands. If we click within the chart and create a chart quickly with alt F1, we get a column chart, and although we see a legend that shows both headings, we don't see the data at all. So let's get rid of that. A better approach might be, in this example, is with the active cell in the data, we don't have to highlight it because it's surrounded by empty cells, although we…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.