Master Advanced Excel & VBA

Learn Excel formulas, data analysis, dashboards, VBA programming, and business automation through structured practical lessons.

COURSE SYLLABUS
1. Excel Basics
Introduction to Advanced Excel Workbook, Worksheets, Rows & Columns Data Types & Cell Formatting Cell References & Keyboard Shortcuts
2. Advanced Excel Formulas
Advanced Formulas Introduction IF, AND, OR & IFERROR Excel Tables XLOOKUP INDEX & MATCH SUMIFS & COUNTIFS
3. Pivot Analytics
Pivot Analytics Introduction Pivot Tables Calculated Fields & Items Timelines & Slicers Text Functions & Data Cleaning
4. Excel Dashboards
Interactive Dashboards Introduction Data Validation Conditional Formatting Combo Charts Sparklines
5. Excel Data Tools
Data Integration Introduction Importing Text Files Power Query Worksheet Protection Formula Auditing
6. VBA Fundamentals
VBA Fundamentals Introduction Macro Recorder VBE Workspace VBA Objects & Properties Variables & Data Types MsgBox & InputBox If...Then...Else Select Case Loops & Dynamic Ranges
7. VBA Automation
VBA Automation Introduction Subroutines & Arguments User-Defined Functions Workbook Events Worksheet Events Form Controls & Buttons
8. VBA UserForms
UserForms Introduction UserForm Design Toolbox Controls Input Validation CRUD Operations with UserForms
9. VBA Optimization & Security
Optimization Introduction Error Handling Debugging Tools Performance Optimization VBA Project Security
10. Corporate Capstone Project
Capstone Project Introduction Data Consolidation Data Cleaning & Analysis Automated PDF Reports Dashboard Automation
11. Excel Practice & Assignments
Practice Introduction Excel Formula Exercises Pivot Table Exercises Dashboard Exercises VBA Programming Exercises Final Assignments

Excel Combo Charts

Learn how to combine column and line charts, use a secondary axis, and compare different types of data in one Excel chart.

1. What Is a Combo Chart?

A Combo Chart, also called a Combination Chart, displays two or more data series using different chart types in a single chart. It is useful when you want to compare values that have different scales or show different types of information together.

  • Column + Line — compare monthly sales and profit percentage.
  • Column + Line with Secondary Axis — compare data with different scales.
  • Column + Area — compare totals and trends.
Example: Display monthly sales as columns and profit percentage as a line so that both the sales amount and profitability trend are easy to understand.

2. Where Is the Combo Chart Option in Excel?

  1. Select your data range, including column headings.
  2. Go to the Insert tab.
  3. Choose Recommended Charts or the chart options available in your Excel version.
  4. Open the Combo chart category, if available.
  5. Choose a chart type for each data series.
  6. Enable Secondary Axis for a series if its scale is different.
  7. Click OK.
Excel Insert Tab — Illustrative Diagram
File Home Insert Page Layout Formulas Data Review View Tables Table PivotTable Charts Column Line Combo Other Insert Options Slicer Timeline Illustrative ribbon — exact options vary by Excel version

3. Sample Data for a Combo Chart

Create a worksheet named MonthlySales and enter the following sample data in cells A1:D7.

Month Sales (₹) Profit (₹) Profit %
Jan50000800016%
Feb620001000016.13%
Mar48000700014.58%
Apr750001400018.67%
May680001200017.65%
Jun820001600019.51%

If Profit % is not already available, calculate it using Profit divided by Sales.

Excel Formula — Profit Percentage
=C2/B2

Enter the formula in D2, format the cell as Percentage, and copy it down through D7. This calculates the profit percentage for each month.

4. Understand the Combo Chart

Monthly Sales and Profit Percentage
Monthly Sales and Profit Percentage 100000 80000 60000 40000 0 Jan Feb Mar Apr May Jun 25% 20% 15% 10% 0% Sales (₹) Profit % Sales (₹) Profit %

Illustrative chart for understanding the layout. Build the actual chart from the sample data to obtain exact plotted values.

  • Blue columns: Sales in rupees.
  • Orange line: Profit percentage.
  • Primary axis: Displays sales values.
  • Secondary axis: Displays profit percentages.

5. Step-by-Step: Create a Combo Chart

Step 1: Select the Data

Select the Month, Sales, and Profit % columns, including their headings. If the columns are not adjacent, select the required series using the method supported by your Excel version.

Step 2: Insert a Combo Chart
  1. Open the Insert tab.
  2. Click Recommended Charts or the Combo Chart option.
  3. Choose the Combo category in the chart dialog.
  4. Set Sales to Clustered Column.
  5. Set Profit % to Line.
  6. Enable Secondary Axis for Profit %.
  7. Click OK.
Step 3: Check the Result

The chart should display sales as columns and profit percentage as a line. Verify that the left axis represents sales and the right axis represents the percentage series.

Step 4: Customize the Chart
  • Set the chart title to Monthly Sales and Profit Percentage.
  • Add axis titles for Sales (₹) and Profit (%).
  • Use distinct colors for the two series.
  • Display data labels if they improve readability.
  • Resize and position the chart neatly in the worksheet.

6. What Is a Secondary Axis?

A secondary axis is an additional value axis used when two data series have different scales or units. For example, sales might be measured in tens of thousands of rupees, while profit percentage ranges from 0% to 25%.

Data Series Unit Recommended Display
Sales Rupees Column chart on the primary axis.
Profit % Percentage Line chart on the secondary axis.
Important: A secondary axis can make trends easier to see, but poorly chosen scales can be misleading. Label both axes clearly and choose appropriate minimum and maximum values.

7. Other Combo Chart Examples

Combination Use Case
Sales Column + Profit Line Compare monthly sales and profitability.
Revenue Column + Growth % Line Compare revenue with growth over time.
Actual Column + Target Line Compare actual performance with a target.
Units Sold Column + Margin % Line Compare product volume and margin.

8. Common Problems and Solutions

Problem Possible Solution
Combo option is not visible. Check the chart options available in your Excel version.
Line series appears too flat. Consider using a secondary axis when the series uses a different scale.
Months appear in the wrong order. Use real dates or arrange the month labels in chronological order.
Chart labels are confusing. Add a chart title, axis titles, and a clear legend.
Profit percentage is incorrect. Check that Profit is divided by Sales and the result is formatted as a percentage.

9. Practical Exercises

Task 1: Sales and Profit

Create a Combo Chart showing Sales as columns and Profit % as a line.

Task 2: Add a Secondary Axis

Display Profit % on the secondary axis and label both axes clearly.

Task 3: Actual vs Target

Create sample monthly actual sales and sales targets, then display actual sales as columns and target sales as a line.

Task 4: Dashboard Chart

Move the finished chart to your Dashboard worksheet and format it to match your other dashboard visuals.

Important Points to Remember

  • Combo Charts combine different chart types in one chart.
  • Use columns for category comparisons and lines for trends.
  • A secondary axis is useful when series have different units or scales.
  • Calculate percentages correctly before creating the chart.
  • Always label axes and use a meaningful chart title.
  • Verify that the chart accurately represents the underlying data.

Summary

Excel Combo Charts combine two or more chart types to show related data together. A common example is displaying monthly sales as columns and profit percentage as a line.

A secondary axis helps display series with different scales. By selecting the right chart types, adding clear labels, and checking the underlying calculations, you can create effective charts for reports and dashboards.