How to Create an Excel Chart for Revenue and Margins Over Time
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.

- 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.
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.
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.
Highlight your entire data table, including the column headers for years, revenue figures, and margin percentages.
Go to the 'Insert' tab on the ribbon, locate the Charts group, click on the 'Combo Chart' icon, and select 'Create Custom Combo Chart'.
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.
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.

Use Two Aligned Charts for Crowded Data
If you are comparing multiple companies and a combination chart becomes too cluttered, place two separate but aligned charts adjacent to each other for clearer comparison.
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. Open your dataset: Launch WPS Spreadsheet and open your financial report containing the revenue and margin data.
- 2. Highlight the data: Select the cells spanning the three-year period, including the labels, revenue, and margin figures.
- 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. Customize and present: Add chart titles, adjust data labels, and format colors to seamlessly finalize your professional financial visualization.

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.




