How to Create a Custom Combo Chart in Excel Mac

Combining different types of data on a single chart in Excel can feel like a puzzle, but it’s one of the best ways to tell a clear and compelling story with your numbers. A custom combo chart is the perfect tool for the job, letting you compare metrics with completely different scales - like revenue in millions of dollars and conversion rates in single-digit percentages. This article will walk you through exactly how to build, customize, and master combo charts in Excel for Mac.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Combo Chart and Why Use One?

A combo chart, short for combination chart, does exactly what its name implies: it combines two or more different chart types into a single visualization. The most common combination is a column chart and a line chart. This dynamic duo allows you to present wildly different types of data together in a way that’s immediately understandable.

So, when would you actually need one? Here are a few common scenarios:

• Comparing data with different units or scales: This is the primary reason to use a combo chart. Imagine you want to see if your monthly marketing spend (e.g., $50,000) is impacting your website's conversion rate (e.g., 2.5%). Plotting these on a standard chart would make the conversion rate line appear completely flat and useless against the scale of your ad spend. A combo chart fixes this by letting you use a secondary axis with its own unique scale.
• Illustrating relationships between metrics: Do higher sales volumes lead to a lower profit margin per item? Does an increase in website traffic correlate with a rise in sales? A combo chart visually connects these metrics, making it easy to spot trends, correlations, or surprising disconnects.
• Showing a target vs. actual performance: You can display your sales goal for each month as a column and then overlay a line chart showing the actual sales achieved. This gives you a quick, at-a-glance view of your progress against targets over time.

Think of it as adding a new layer of depth to your reporting. Instead of just presenting isolated numbers, you're providing context and revealing the story behind the data.

Preparing Your Data for a Combo Chart

Before you can make a beautiful chart, your data needs to be organized properly. Garbage in, garbage out is a timeless rule in data analysis, and it's especially true for charting. A clean, simple table structure is your best friend here.

For a combo chart, your data should typically be arranged in three or more columns:

• Column 1 (Categories): This is your horizontal axis (X-axis). It usually contains time periods (like months, quarters), product categories, or campaign names.
• Column 2 (Data Series 1): This is your first numerical value. For example, 'Sales Revenue'. It will likely be a column chart and use the primary vertical axis (Y-axis) on the left.
• Column 3 (Data Series 2): This is your second numerical value, often with a different scale. For example, 'Units Sold' or '% Click-Through Rate'. This will likely be a line chart that uses the secondary vertical axis on the right.

Example Data Structure

Let's say a marketing manager wants to compare monthly advertising spend against the number of new leads generated. Their data in Excel should look something like this:

Here, 'Ad Spend' will be our columns, and 'New Leads' will be our line. Because the values are quite different (tens of thousands vs. hundreds), we'll definitely need that secondary axis.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Guide to Creating a Custom Combo Chart in Excel for Mac

With your data neatly organized, creating the chart is a straightforward process. Just follow these steps.

Step 1: Select Your Data

Click and drag your cursor to highlight the entire range of data you want to include in the chart. Make sure you include the column headers (e.g., 'Month', 'Ad Spend ($)', 'New Leads'). Including the headers tells Excel what to label each data series automatically.

Step 2: Insert a Combo Chart

With your data selected, navigate to the Insert tab in the main Excel ribbon at the top of your screen. In the 'Charts' section, look for an icon that looks like a small column chart with a line chart overlaid on it. This is the 'Insert Combo Chart' button.

Click this icon. A dropdown menu will appear with a few default combo chart options. You can ignore these for now and go straight to the most powerful option at the bottom.

Step 3: Choose 'Create Custom Combo Chart...'

At the bottom of the dropdown menu from the previous step, click on Create Custom Combo Chart... (it may also be labeled as 'More Combo Charts...' in some versions). This opens up the 'Change Chart Type' dialog box, which is command central for building your perfect chart.

Step 4: Customize Chart Types and Axes

This is where the magic happens. In the dialog box, you'll see a section titled Choose the chart type and axis for your data series. It lists each of your numerical data series (e.g., 'Ad Spend' and 'New Leads') and gives you two options for each:

• Chart Type: Use the dropdown next to each data series to select how you want it to be visualized. A common choice is 'Clustered Column' for your primary data and 'Line' or 'Line with Markers' for your secondary data.
• Secondary Axis: This is the most important part. For the data series with the vastly different scale (in our example, either one could work, but let's put 'New Leads' on the secondary axis), check the box in the 'Secondary Axis' column.

As you make these changes, Excel provides a live preview of what your chart will look like. For our example, you would set 'Ad Spend' as a Clustered Column on the primary axis and 'New Leads' as a Line with the 'Secondary Axis' box checked.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 5: Click OK

Once you are happy with the preview, click 'OK'. Your custom combo chart will instantly appear on your spreadsheet. The basic structure is done, but now it's time to refine it to make it look professional and easy to read.

Formatting and Customizing Your Combo Chart for Clarity

A default chart gets the job done, but a well-formatted chart communicates its message effectively. Here’s how to polish your new combo chart.

Editing Chart Titles and Axis Labels

Your chart needs clear labels so everyone knows what they're looking at. Start by clicking on the 'Chart Title' at the top and typing something descriptive, like "Ad Spend vs. New Leads Generated."

Most importantly, you must label your secondary axis. By default, it won't have a title. To add one:

1. Make sure your chart is selected.
2. Go to the Chart Design tab in the ribbon.
3. On the far left, click Add Chart Element.
4. Hover over Axis Titles and select Secondary Vertical.
5. A new title box will appear. Click it and type its label (e.g., "Number of New Leads").

You can do the same for the primary vertical and horizontal axes to add clarity.

Adjusting Colors and Styles

Under the Chart Design tab, you can use the 'Change Colors' option to select a predefined color palette or choose from dozens of pre-built 'Chart Styles' that add effects like shadows and gradients. It's good practice to choose colors with high contrast to make the columns and line easy to distinguish.

Adding Data Labels

Sometimes you want to show the exact values on the chart. To do this, right-click on either the columns or the line and select Add Data Labels. This will place the exact numerical value next to each data point, saving your audience from having to guess based on the axis lines.

Cleaning Up the Axes

Do your axis numbers look sloppy? Right-click on any axis and choose Format Axis.... This opens a panel where you can control everything:

• Change the number format to Currency or Percentage.
• Adjust the minimum and maximum bounds to focus on a specific range.
• Change the interval between gridlines ('Major Units').

Common Pitfalls and Troubleshooting Tips

Creating a combo chart is usually smooth, but a few common issues can trip you up. Here’s what to look out for.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

My Line Chart Looks Flat!

This is almost always because you forgot to assign the second data series to the secondary axis. When two series with vastly different scales (like 50,000 and 5) share the same axis, the smaller one gets squashed to the bottom.

The Fix: Right-click your chart, choose 'Change Chart Type', and simply check the 'Secondary Axis' box for the appropriate data series.

My Chart Data is Wrong

If the chart isn't showing what you expect, check your initial data selection. It's easy to accidentally include an extra row or forget to include your headers.

The Fix: Right-click the chart and select 'Select Data...'. A dialog box will appear showing you the exact range being used. You can edit it directly from here without having to recreate the chart from scratch.

The Chart is Confusing and Overcrowded

This happens when you try to plot too many things at once. Combo charts work best with two, or at most three, data series.

The Fix: Simplify! Focus on the most important relationship you want to show. Remember that clear titles for the chart and both vertical axes are non-negotiable for making your chart understandable.

Final Thoughts

Creating a custom combo chart in Excel for Mac is a powerful way to visualize relationships between different kinds of data on one canvas. By combining chart types and using the secondary axis, you can turn a confusing set of numbers into a clear, insightful story that anyone can understand in seconds.

Manually wrangling data in spreadsheets, remembering the right chart settings, and updating reports week after week is time-consuming. We built Graphed to remove that friction completely. You can connect your marketing and sales data sources just once, and then use simple, natural language to create real-time dashboards. Rather than clicking through menus, you can just ask, "Show me a chart comparing my Facebook Ads spend versus my Shopify revenue over the last quarter," and get an interactive chart in seconds, automatically updated with live data.