In this tutorial, we’ll explore what a secondary axis is, why you need it, and how to add it step by step in Excel. By the end, you’ll be able to compare data with different scales like a pro.
Table of contents [Show]
A secondary axis is an additional vertical (or horizontal) axis added to a chart. It allows you to plot two different data series that use different value ranges.
For example:
Plotting both on the same axis would squash one line flat. The secondary axis solves this problem by giving each data series its own scale.
Rule of thumb: Use a secondary axis only when it improves clarity, not complexity.
Let’s use a simple sales and profit example.
| Month | Sales (₹) | Profit % |
|---|---|---|
| January | 120000 | 18% |
| February | 150000 | 22% |
| March | 170000 | 25% |
| April | 140000 | 20% |
Here, Sales values are large numbers, while Profit % is a small percentage range—perfect for a secondary axis.
Instantly, Excel adds a second vertical axis on the right side of the chart.
This is my favorite approach because it gives you full control.
You now have a clean, professional-looking chart showing both values clearly.
Right-click the secondary axis → Format Axis → adjust minimum, maximum, and major units.
Right-click Axis → Format Axis → Number → Percentage
Always label both axes:
This avoids the classic “What am I looking at?” moment for your audience.
Pro tip: If you have to explain the chart for more than 30 seconds, simplify it.
I once used a secondary axis chart to show website traffic and conversion rate in a client report. Traffic was in thousands, conversions in percentages. Without a secondary axis, the conversion line was invisible. With it? Crystal clear—and the client loved it.
Adding a secondary axis in Excel is not just a charting trick—it’s a storytelling tool. It helps you compare different metrics without sacrificing clarity.
Practice with your own data, experiment with combo charts, and always ask: Does this make my message clearer?
If you’ve ever looked at a financial report or a sales dashboard and wondered, “How did they visualize this so clearly?”, chances are you saw a Waterfall or a Funnel chart.
These two charts are not just visually appealing — they are powerful tools for explaining change and progress.
Sparklines are miniature charts that fit neatly inside a single Excel cell. They display trends or variations in a series of data points — such as sales performance, temperature changes, or stock prices — without taking up much space.
If you’ve ever had to constantly update a chart every time new data was added, you probably know the frustration. But what if I told you there’s a smarter, automatic way? Yep — today we’re diving into Dynamic Charts in Excel using Named Ranges
