Categories
Displaying insights into the relationship between more than one different data series is easier said than done.
Why?
It’s incredibly easy for you to use the wrong charts, which may mislead your target audiences. Charts that can reveal hidden insights into the relationship between more than one different variable are limited.
Well, the Double Y-axis Graphs are among those limited visualization charts. Besides, these charts come in 4 variants, namely:
The main benefit of this group of charts is they spare you the time and effort needed to create two charts for the same data store.
You don’t want to miss the rest of the blog if your goal is to take your data storytelling expertise to the All-Star level.
In this blog you will learn:
You can use the Double Y-axis chart to plot more than one different data series.
This chart achieves the task (above) using a secondary Y-axis on the right-hand side. More so, you can use the Double Y-axis Chart to display the relationship between two variables. In other words, this chart is convenient for uncovering hidden insights into the relationship between two or more measures with different scales and measures.
There are 4 types of Double Y-axis visualization design, namely:
Charts with double y-axes can help you save time because of its ability to display critical insights using limited space.
Here’s an interesting fact.
You can use these charts to visualize more than one different variable without worrying about clutter and other issues that can obscure critical insights.
You can leverage the Double Y-axis Chart maximally in the following scenarios (below):
For instance, you can compare the US and Canada’s gross domestic product (GDP) in the same chart across a specified time (dimension variable).
For instance, you can compare life expectancy with the US economic growth across a specified time.
Excel lacks charts with double y-axes in its library. Essentially, you have to add a secondary axis Excel manually in a super time-intensive process.
You don’t have to undergo all this.
You can install third-party add-ins into your Excel to access insightful and easy-to-interpret Double Y-axis Graphs.
There are over 2,000 add-ins purposely designed for Excel.
To simplify things, we’ve installed and tested over 40 data visualization-based add-ins.
We narrowed down our results based on the following factors: ease of use, cost of access, quality of visualization chart, and the size of the chart library.
The Excel add-in that met all our conditions is ChartExpo. With ChartExpo, you don’t have to add a secondary axis in Excel manually.
Yes, this tool comes with ready-made charts that need minimum editing, such as adding a title and legends.
Let’s take a closer look at ChartExpo.
Brief introduction of ChartExpo
ChartExpo is an Excel-based add-in with an ultra-friendly user interface to ensure that any professional can visualize data, irrespective of their coding or programming skills.
This easy-to-use add-in comes loaded with super-advanced Double Y-axis Graphs, such as
We’re confident this is the tool you need to use minimum space to display critical insights into more than one different data series.
You don’t have to plot an extra chart or add a secondary axis in Excel manually.
ChartExpo’s charts are read-made, meaning you can deploy them in your data stories without getting subjected to time-intensive customizations.
In the coming section, we’ll take you through the four types of Double Y-axis Graphs:
The Double Axis Line and Bar Chart can help you compare more than one different metric across time without having to plot extra diagrams.
Let’s visualize the sample data below using the Double Axis Line and Bar Chart.
Note: You don’t have to add a secondary axis in Excel manually. This is because the chart (above) comes ready-made with two y-axes.
| Year | Sales | Profit Margin % |
| 1998 | 22.23K | 7.2 |
| 1999 | 19.87K | 8.2 |
| 2000 | 18.22K | 6.8 |
| 2001 | 27.67K | 7.5 |
| 2002 | 22.7K | 4.8 |
| 2003 | 15.76 K | 6.1 |
| 2004 | 16.85 K | 7.1 |
| 2005 | 17.54 K | 8.4 |
| 2006 | 16.14 K | 7.3 |
| 2007 | 16.33 K | 8.9 |
| 2008 | 16.43 K | 5.6 |
| 2009 | 16.34 K | 4.5 |
| 2010 | 16.21 K | 6.4 |
| 2011 | 16.52 K | 7.9 |
| 2012 | 16.42 K | 8.3 |
| 2013 | 16.17 K | 9 |
| 2014 | 15.57 K | 4.6 |
| 2015 | 16.48 K | 9 |
| 2016 | 16.34 K | 6.8 |
| 2017 | 14.99 K | 7.9 |
| 2018 | 17.26 K | 9.6 |
| 2019 | 13.67 K | 6.9 |
| 2020 | 12.32 K | 4.3 |
| 2021 | 11.28 K | 5.6 |
To get started with the Double Y-axis chart maker in ChartExpo, If you have not already installed it, you can click here to get it then please follow the easy steps below.
The Area Line Chart (also called an Area Line Graph) is a Double Y-axis Graph variant that shares similarities with an Area Graph.
This chart (above) can help you display insights into the relationship between more than one different data series over a specified time. You can achieve the above using a line curve and shaded area using two y-axes, as shown below.
Use ChartExpo to generate easy-to-read and insightful Area Line Charts.
You don’t have to add a secondary axis in Excel manually when using this tool.
Visualization Source: ChartExpo
The Dual Axis Grouped Bar Chart is a Double Y-Axis Graph type that shares similarities with the Bar Chart.
It has two y-axes to display data for more than one different metric.
Take a look at the chart below
The blue bars on the left side show insights into GPD per capita (y-axis). Similarly, the grey bars show life expectancy insights.
A Vertical Axis Line Chart is a Double Y-axis Graph type you can use to display metrics with different measures or magnitudes.
You can easily pick hidden trends and patterns in your data using this chart. Remember, you don’t have to add a secondary axis in Excel manually when using this ChartExpo.
To get started with ChartExpo, follow the easy steps below:
You can create this visualization with your own data as well. You don’t need to every time go on sample data. You can have your own data and directly create your own visualization.
How to add a secondary axis in Excel with your own data?
Let’s visualize Your own data using the Double Axis Line and Bar Chart.
| Days | Sales | Purchase |
| Mon | 19000 | 16300 |
| Tue | 12000 | 10500 |
| Wed | 9000 | 6500 |
| Thu | 16500 | 15000 |
| Fri | 9600 | 9500 |
| Sat | 5000 | 4500 |
| Sun | 7000 | 4000 |
To draw this chart on actual values you need to go to the Settings section on top of the window check the section Chart Drawing and then select from drop down Value based, by default it was percentage base.
Once selected then click on Apply button to see the changes as shown below.
Like we said, how to add a secondary in Excel should never stress you or even consume a lot of your time. You chart is ready what you can do now is you can click on Edit Chart Button to see pencil icon on different area further click and change the more properties according to your requirement. Like you can add header, on top and left and right axis, can change the color of axis, can add prefix “$” sign.
Once you are done with properties changes you can click on Save Changes to preserve all the altered properties.
Your final image may look like this:
In fact, you should never add a secondary axis in Excel manually in light of the information you’ve read in this blog post.
One of the most significant benefits of this visualization design is its ability to display insights into the relationship between 2 metrics.
Furthermore, the metrics you’re tracking in your data do not need a similar scale or measure to use the chart.
Secondly, charts with double y-axes allow you to save space by performing the work of two graphs. How?
As we said, The Double Y-axis Diagrams come with secondary axes to enable you to display more than one different data series simultaneously.
You don’t have to visualize your data using two charts.
There’s a famous saying that goes, “Bring a gun to a knife fight.” Please note we don’t advocate violence, but we find the phrase (above) relevant.
A gun can prove the decisive factor in a knife fight—similarly, the Double Y-axis Graphs outperform other traditional visualization designs in complex tasks that require two or more.
Take a look at a screenshot of the graph below.
Visualization Source: ChartExpo
Later in this blog, you will see how the above chart can be created in Excel. There is another example below of a double y-axis.
The chart above displays two different KPIs. Note the y-axes have more than one different scale but share the x-axis.
The visualization above confirms that the Double Y-axis Graph is the proverbial gun in a knife fight.
Use these charts to visualize more than one different data series rather than deploy two charts. You’ll save a lot of space in your data visualization dashboard.
To get the most from Double Y-axis graph types (Double Axis Line and Bar, Area Line, Dual Axis Grouped Bar, and Vertical Axis Line Charts), use data with different metric units.
A chart can only hold so much information before it becomes overwhelmed or appears cluttered. Stick to making one point with your chart.
Just because you have two y-axes doesn’t mean data visualization best practices don’t apply.
For example, a line chart is hardly the best way to represent categorical data. They’re best reserved for trends over time.
You can use the double-y-axis graphs to plot more than one different data series. You can achieve this using a secondary y-axis on the right-hand side.
These visualization designs display insights into the relationship between two variables. Besides, they’re incredibly handy in uncovering hidden insights into the general trends and patterns between two or more metrics.
One of the advantages of this visualization design is its ability to display insights into the relationship between 2 varying metrics. The metrics you’re tracking in your data do not need similar scales or measures when using these charts.
The Double Y-axis Chart can save you space by performing the work of two charts.
You’ll agree when we say visualizing more than one different metric with varying scales using traditional charts, such as Bar Graphs is challenging. You need specialized data visualization charts to get reliable insights.
This is where Double Y-axis Graphs come in.
You can use these charts to visualize more than one different data series without plotting more diagrams. Yes, you read that right.
Besides, you can easily save a lot of space in your dashboard by constricting insights from different variables into a single chart.
There are 4 types of Double Y-axis Graphs:
Excel should not be your go-to tool if want charts with double y-axes.
Why?
This spreadsheet application’s library lacks the Double Y-axis Graphs templates. Essentially, you have to add a secondary axis in Excel manually. And this means you’ve to spend more of your valuable time.
But we’re not recommending you to do away with Excel. No.
Just install third-party apps, such as ChartExpo, into your Excel to access visualization designs with two y-axes.
ChartExpo is an add-in you can easily download and install in your Excel app. More so, it’s loaded with over 50 more advanced charts. You don’t need programming or coding skills to visualize your data using ChartExpo.
Sign up for a 7-day free trial today to access easy-to-interpret and visually appealing Double Y-axis Graphs for your data story.
How much did you enjoy this article?
We will help your ad reach the right person, at the right time
Actionable insights discovered for you. Now you can do more in less time.
PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.
Frequent audits will help you optimize your PPC campaign for success.
Visualizations give you the ability to instantly grasp the insights hidden in your numbers.
Experience the new revolution in reporting … click your way to insights, don’t scroll.
Calculate the number of combinations in your PPC campaign. It may surprise you.
Related articles
What is causal analysis? It's a method to find the root cause of problems. This blog explains the types, methods, and steps for causal analysis.
This blog explains ABM, its benefits, and types. You’ll learn how to create and implement an ABM strategy to improve ROI and build strong client relationships.
Learn how to make a table in Google Sheets with easy-to-follow steps. This guide covers everything from using pre-built templates to customizing your table.
