Chart & Visualization Issues

How to Create an Excel Chart for Revenue and Margins Over Time

Rana GarciaRana Garcia Nov 10, 2026 871 views

Question details

The user wants to build a combination chart displaying revenue on a primary axis and margins on a secondary axis over multiple years.

How to Create an Excel Chart for Revenue and Margins Over Time
Product
Excel
Device & OS
not provided
Scenario
Creating financial data visualizations to compare revenue and margin trends across a three-year period.
Observed behavior
Needing a way to plot absolute currency values alongside percentage values without flattening the smaller percentage numbers, specifically by utilizing secondary axes and combination charts.
Before you start

Ensure your data is organized in a clear tabular format, with years (e.g., 2021, 2022, 2023) clearly labeled and separate rows or columns for revenue figures and margin percentages.

Solution 1Recommended

Create a Combination Chart with a Secondary Axis

Build a single combination chart that plots revenue as columns on the primary axis and margin percentages as a line on the secondary axis to compare both metrics simultaneously.

A combination chart allows you to use different chart types for different data series. By putting margin percentages on a secondary axis, you prevent them from being visually squashed by the much larger revenue numbers.

1
Select your data

Highlight your entire data table, including the column headers for years, revenue figures, and margin percentages.

2
Insert a Combo Chart

Go to the 'Insert' tab on the ribbon, locate the Charts group, click on the 'Combo Chart' icon, and select 'Create Custom Combo Chart'.

3
Configure the axes

In the Insert Chart dialog box, set the Revenue series chart type to 'Clustered Column' and leave the Secondary Axis box unchecked. Set the Margin series to 'Line' and check the 'Secondary Axis' box, then click OK.

4
Switch Row/Column if necessary

If Excel plots the years as lines instead of placing them on the bottom horizontal axis, right-click the chart, choose 'Select Data', and click the 'Switch Row/Column' button.

Create a Combination Chart with a Secondary Axis
Visual Clarity: Using dual axes ensures that both trends (growth in revenue and fluctuations in margin) are clearly visible at a glance.
Create Combo Charts Easily

Visualize Financial Data with WPS Spreadsheet

WPS Spreadsheet makes it simple to build complex financial visualizations, including combination charts with secondary axes. Fully compatible with Microsoft Excel, it helps you easily plot revenue and margin data for professional reporting.

  1. 1. Open your dataset: Launch WPS Spreadsheet and open your financial report containing the revenue and margin data.
  2. 2. Highlight the data: Select the cells spanning the three-year period, including the labels, revenue, and margin figures.
  3. 3. Insert a Combo Chart: Navigate to the 'Insert' tab, select 'Combo Chart', and assign the margin data to a line chart on the Secondary Axis.
  4. 4. Customize and present: Add chart titles, adjust data labels, and format colors to seamlessly finalize your professional financial visualization.
Create complex combo charts with primary and secondary axes in just a few clicks.Fully compatible with Microsoft Excel (.xlsx) formats, ensuring your charts display perfectly.Completely free, lightweight, and features an intuitive interface similar to Microsoft Office.
QA img-9

Frequently Asked Questions

Why are my margin lines flat at the bottom of the chart?

This happens because profit margins are small percentages (e.g., 0.15 for 15%), whereas revenue often involves large numbers (e.g., 500,000). To fix this, right-click the margin line on your chart, select 'Format Data Series', and choose 'Secondary Axis' so it scales properly.

How do I fix it if Excel puts my years as a data series instead of the axis?

If Excel misinterprets your years (like 2021, 2022) as numbers to be plotted rather than axis labels, right-click anywhere on the chart, click 'Select Data', and then click the 'Switch Row/Column' button.

Can I add data labels to just the margin line?

Yes. Click exactly on the line representing the margins to select only that data series. Then, right-click the line and choose 'Add Data Labels' to display the percentages without cluttering the revenue columns.