From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Basic combo charts

Basic combo charts - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Start my 1-month free trial Buy for my team

Basic combo charts

“

- [Christopher] One of Excel's most powerful data visualization capabilities, is the option to combine charts together to form custom combo charts. Now obviously there are hundreds if not thousands of ways to combine different charts. But in this case I'm going to show you a few examples just to give you a sense of how these things work. So on the Combo Charts tab you'll see this data set here, now I've got a combination of volume metrics like Desktop Spend, Total Spend, Clicks and Transactions as well as rate metrics. Like Cost per Click and Transaction rate. Now the reason that's worth noting, is because those two types of metrics, volumes versus rates tend to fall on completely different scales, and as a result trying to visualize them or plot them on the same charts or graphs means that you really need to combine different types and use things like secondary axes to tell a meaningful story. So I'm going to start by inserting a basic 2D column chart and let's drag it right down…

Contents