• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

Excel Combo Chart

Home » Excel » Excel Charts » Excel Combo Chart

By Harshada Khot Leave a Comment

Excel Combo Chart

Excel Combo Chart (Table of Contents)

  • Combo Chart in Excel
  • How to Create a Combination Chart in Excel?

Combo Chart in Excel

Combo Chart is the combination of different chart types to show the different or same set of data which are related to each other in nature. With a normal chart, we will have two-axis i.e. “X-Axis & Y-Axis”. However, this is not the same thing with combo charts, because this time we will have two Y-Axis instead of the traditional one Y-Axis.

The typical example of showing the combo chart is “Revenue vs Profit %”. We will see how to create a combo chart with excel.

How to Create a Combination Chart in Excel?

Below are the examples of combo chart in excel.

You can download this Combo Chart Excel Template here – Combo Chart Excel Template

Example #1

If you are in data team with the management you may require to do a lot of analysis, one of such analysis is comparing revenue against the profit percentage.

For this example demonstration, I have created the below data.

Excel Combo Chart Example 1

With this data, we will show you how to create a combo chart. Follow the below steps –

Step 1: Select the entire data first.

Example 1.1

Step 2: Go to Insert >>> Charts >>> Column Chart >>> Clustered Column Chart.

Excel Combo Chart Example 1.2

Step 3: Now we will have a chart like below one.

Example 1.3

This isn’t the combo chart because here we have only column clustered chart, so we need to change “Profit %” data to the line chart.

Popular Course in this category
Cyber Monday Sale
All in One Excel VBA Bundle (35 Courses with Projects) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,353 ratings)
Course Price

View Course

Related Courses
VBA Macros CourseAdvanced Excel CourseTableau Certification Course

Step 4: Right click and select “Change Chart Type”.

Excel Combo Chart Example 1.4

Now we will see below window.

Example 1.5.0

Step 5: Now select “Combo” option which is there right at the bottom.

Excel Combo Chart Example 1.6

Step 6: In this “Combo” we can see chart preview and various other recommended charts. For-profit chart selects the chart as “Line” and makes check the box “Secondary Axis”.

Example 1.7

Step 7: Click on Ok, we will have a combo chart now.

Excel Combo Chart Example 1.8

Now we can see on the right-hand side of the chart we have one more Y-Axis which represents the line chart numbers.

Example 1.9

Now with this chart, we can make some easy interpretations.

  • In the month of Feb, we got the lowest revenue so does profit percentage as well.
  • But when we look at the Jun month we have the second-lowest revenue but profit percentage is very high among all the other months.
  • In the month of Jan even though revenue is 41261 $ profit percentage is limited to just 12.5% only.

Example #2

Now I have created slightly different data. Below is the data for this example.

Excel Combo Chart Example 2

Here, instead of a profit percentage, we have Profit numbers and in addition, we have units sold data as well.

So, here we need to decide which is to show in the secondary axis, this is key here. This time we will create a chart through manual steps.

Step 1: Insert a blank chart and right-click on the chart and choose Select Data.

Excel Combo Chart Example 2.1.0

Step 2: In the below window click on “Add”.

Excel Combo Chart Example 2.2

Step 3: In the below window, in “Series Name” choose B1 cell and in Series Values select B2 to B7. Click on Ok.

Excel Combo Chart Example 2.0.3

Step 4: Click on “ADD”.

Excel Combo Chart Example 2.4

Step 5: In the below window select “Month” names. Click on OK.

Excel Combo Chart Example 2.0.5

Step 6: Repeat the same steps for “Profit” and “Units Sold” data as well. Now we will have a chart like below.

Excel Combo Chart Example 2.6.0

Step 7: Right-click and choose “Change Chart Type”.

Example 2.7

Step 8: Select “Combo” option from below window. and for “Units Sold” series name choose “Line” chart and check the box “Secondary Axis”.

Excel Combo Chart Example 2.8

Step 9: Now for “Profit” series name choose “Area” chart but do not check the “Secondary Axis” checkbox.

Example 2.9

Step 10: Now we will have a chart like below.

Excel Combo Chart Example 2.10

Note: I have changed the series colors.

Things to Remember

  • These are the steps involved in the Excel 2016 version.
  • It is necessary to check the box “Secondary Axis” to have Y-Axis at the right side.
  • Change necessary colors as per the convenience.

Recommended Articles

This has been a guide to Excel Combo Chart. Here we discuss how to create a combo chart in excel along with practical examples and a downloadable template. You may learn more about excel from the following articles –

  • Make Plots in Excel | With Makers
  • How to Make Animation Chart in Excel?
  • Dot Plots in Excel
  • 4 Types of Control Charts in Excel
  • Stock Chart in Excel Examples
  • Tornado Chart in Excel Examples
  • Make 3D Maps in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel, Excel Charts

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Combo Chart Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

CYBER WEEK OFFER - All in One Excel VBA Bundle (35 Courses with Projects) View More