• Home
  • Tools
    • PPC Signal
    • PPCexpo Keyword Planner
    • PPC Audit
    • ChartExpoTM PPC Charts
    • PPCexpo PPC Reports
    • Combinations Calculator
  • Pricing
  • Contact us
  • Resources
    • PPC Signal Dashboard
    • PPC Reports Templates
    • PPC Guide
    • Join Our Facebook Group
    • Charts
      • CSAT Score Survey Chart
      • Likert Scale Chart
      • Pareto Chart
      • Sankey Diagram
  • Blog
Categories
All Digital Marketing PPC SEO SMM Data Visualization
All Digital Marketing PPC SEO SMM Data Visualization

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok
Home > Blog > Digital Marketing > Data Visualization >

How to Add a Secondary Axis in Excel? Easy Steps to Follow

Using charts with secondary axis in your data stories is an opportunity you would kill for if only you knew the benefits.

how to add a secondary axis in excel
how to add a secondary axis in excelhow to add a secondary axis in excel

Well, the main benefit of a secondary axis is you actually don’t need to plot two charts to visualize two varying metrics in your data.

Yes, you read that right.

A secondary vertical axis provides you with the ability to plot multiple data series on the same chart. You can visualize multiple data series in a single chart, thus saving space.

We understand Excel is one of the most trusted visualization tools out there. However, plotting charts with two y-axes in Excel is not a walk in the park.

Essentially, you have to add secondary axis in Excel manually, which is a time-intensive process.

Imagine what it would be like to visualize your data with Double Y-axis Charts without doing away with Excel. Yes, it’s possible.

You just need to download and install an add-in (which we’ll talk about later) into your spreadsheet tool. How to add a secondary axis in Excel does not have to be time-consuming or overwhelming.

This blog will walk you through how you can access ready-made charts with double y-axes.

You don’t have to add a secondary axis Excel manually.

How to Add a Secondary Axis in Excel for More Comparison Insights?

Before we delve into the how-to guide, let’s define the secondary axis and why you need it in your data story.

What is a Secondary Axis in a Chart?

You can use the secondary axis to display insights into two different data sets within a single chart. A typical Cartesian-based chart has x and y-axes.

But a Double Axis Graphs come with two y-axes and an x-axis.

Why Should You Add a Secondary Axis to your Charts?

A secondary axis can help you to display insights into more than one data series.

Essentially, you can visualize two different variables by using two y-axes on either side of your chart. And this means you can easily extract comparison insights, irrespective of the magnitude of the data.

A Secondary Axis can help you emphasize the key data points within categories. More so, you can make comparisons between categories using a high contrasting color scheme.

If you want to use limited space in your data visualization dashboard, your go-to charts should have a secondary axis. You have an option of adding a secondary axis in Excel manually, which is time-intensive for sure.

The other option is going for ready-made and advanced charts with double y-axes, such as:

  • Double Axis Line and Bar Chart
  • Area Line Chart
  • Dual Axis Grouped Bar Chart
  • Vertical Axis Line Chart

Think for a moment the amount of time you stand to save by using ready-to-use charts for your data stories.

There’re tools that come with ready-made charts. Yes, charts with a secondary axis to help you display insights into two different data series. Keep reading to discover more.

Advantages of using Secondary Axis

  • Simplified Data Analysis

Charts with two y-axes can simplify your analysis phase, irrespective of the complexity of the data.  More so, they can help you compare two different variables within your data for insights.

  • Track Data Changes

You can use charts with secondary axes to map and track changes of key metrics over time.

Unlike other typical Cartesian-based charts, visualization designs with double y-axes can help you display insights into different data sets over a given time.

  • Data Comparison

Use charts with secondary y-axes, if you have two data series with varying scales.

For instance, you can compare the US and Canada’s gross domestic product (GDP) in the same chart across a specified time (dimension variable).

How to Add a Secondary Axis in Excel?

We acknowledge that Excel is among the most-used data visualization tools by a majority of professionals and businesses. Besides, it has been there for decades, plus it’s familiar to many.

How to add a secondary axis in Excel does not have to be time-consuming or nerve-wracking.

Why?

We’ll show you how you can supercharge your Excel to access ultra-advanced charts in the next section. Essentially, you’ll learn how to install third-party add-ins into your Excel to access charts with the secondary axis.

how to add a secondary axis in excelhow to add a secondary axis in excel

Try ChartExpo for Awesome Visualizations

ChartExpo has an ultra-friendly user interface to spare you the stress of learning programming or coding to visualize your data.

Furthermore, this tool has super-advanced charts with secondary axes you’ll never find in Excel, such as Double Axis Line and Bar and Area Line charts.

With ChartExpo, you don’t have to add secondary axis in Excel manually. Yes, you read that right. ChartExpo has ready-made charts that require minimum edits, such as adding a title and legends.

How to add a secondary axis in Excel should be a thing of the past for you. In the coming section, we’ll usher you into the new era of ready-made charts with double y-axes.

How to Visualize your data with ChartExpo Add-in for Excel

Make sure you already have installed ChartExpo in Excel.

To get started with ChartExpo, follow the easy steps below:

  • Open the worksheet and click the Insert button to access the My Apps option.
  • Click the My Apps button and click the See All button to view ChartExpo, among other add-ins.
how to add a secondary axis in excel
  • Select ChartExpo add-in and click the Insert button.
how to add a secondary axis in excel
  • Log in with your Microsoft account or create a new account by clicking the Create New link
  • Provide ChartExpo with all the necessary permission for it to function reliably within your Excel.

How to add a secondary axis in Excel does not have to be time-intensive. Keep reading to discover more.

how to add a secondary axis in excel

Once you will logged in you will see ChartExpo Visualization list.

how to add a secondary axis in excel

Click the Search box and type “Double Axis Line and Bar Chart.”

how to add a secondary axis in excel

You will see following window. You can click on Add Sample Chart+Data to see the sample data which is required to draw this chart. Later you can replace that data with your own and see the final visualization.

how to add a secondary axis in excel

As soon as you will click on this button you will see double axis bar chart visualization with sample data.

how to add a secondary axis in excel
how to add a secondary axis in excelhow to add a secondary axis in excel

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
  • You might have seen sample data visualization before but to visualize the data above you can copy paste it in Excel. Select the columns and rows and then click the Create Chart from Selection button, as shown below.
how to add a secondary axis in excel
  • Check the first look of the chart below. This chart is created on percentage values.
how to add a secondary axis in excel
how to add a secondary axis in excelhow to add a secondary axis in excel

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.

how to add a secondary axis in excel

Once selected then click on Apply button to see the changes as shown below.

how to add a secondary axis in excel

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.

how to add a secondary axis in excel

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:

how to add a secondary axis in excel
how to add a secondary axis in excelhow to add a secondary axis in excel

In fact, you should never add a secondary axis in Excel manually in light of the information you’ve read in this blog post.

Insights

  • Green bars and lines are showing sales data whereas red lines are showing purchase data.
  • On Wednesday and Sunday, purchases surpassed the sales.
  • On Thursday, sales outperformed purchases.sss
  • P1 in the last of the x-axis showing the predictive points
  • Overall trend of purchase and sales are going downward by the end of week.

How to add a secondary axis in Excel should never consume your valuable time. Use ChartExpo’s Double Axes Charts and have beautiful visualization for your dataset.

Best Practices to Follow When using Double Axis Line and Bar Chart

  • Consider the ordering of categories in data

Consider the order to use when plotting bars in this chart.

One of the recommended strategies is sorting the bars from the longest to the shortest. Ordering can help your target audience (or readers) to interpret the chart.

  • Use color wisely

Consider the color scheme to use to create contrast when you add secondary axis Excel.

  • Label bars directly

We recommend you label your chart with relevant titles and legends. Labeling can help your audiences interpret charts in your data stories faster.

However, avoid cluttering your chart with excessive labels, which can obscure critical insights.

  • Size and spacing of bars

The spaces between each bar should not be bigger than the width of each bar. And this is because your chart may overextend beyond the margins of your dashboard.

On the other hand, if bars are closely knitted together, they can obscure key insights or render your chart visually unimpressive.

As we said, how to add a secondary axis in Excel does not have to be nerve-wracking or time-consuming.

FAQs:

What is the use of the secondary axis?

The secondary axis allows you to visualize two different data series without the need for additional charts.

A typical Cartesian-based chart has x and y axes. But a Double Axis Graphs come with two y-axes and an x-axis. The secondary y-axis is located on the right side of the Double Axis charts.

How can you create a secondary axis in Excel?

Excel spreadsheet’s library lacks charts with secondary axes. Essentially you have to add a secondary axis in Excel manually, which is time-intensive.

But, you can supercharge your Excel with third-party add-ins, such as ChartExpo, to access visualization designs with two y-axes, such as the Double Axis Line and Bar Charts.

Wrap Up

Visualizing two different data series with varying scales in one chart is challenging. You need specialized visualization designs to get reliable insights.

This is where charts with secondary axes come in.

You can use charts with two y-axes to visualize varying data series without plotting more diagrams. Yes, you read that right. Besides, you can easily save a ton of space in your dashboard by displaying different metrics within a single chart.

We recommend you to think beyond Excel if you want to access charts with secondary axes.

Why?

Excel is most loved demanding tool no doubt by many experts but sometimes needs more effort and time to achieve the results with two axis with awesome visualization. Essentially, you have to add secondary axis in Excel manually, which is time-consuming and complex. But, we’re not recommending you to do away with Excel. We recommend you install third-party apps, such as ChartExpo into your Excel to access advanced charts with double y-axes.

You don’t have to add secondary axis Excel manually. Let tools, such as ChartExpo do that work on your behalf.

ChartExpo is an add-in you can easily download and install in your Excel app. Besides, this tool comes loaded with insightful and easy to interpret charts with a secondary axis.

Here’s the bottom line: You don’t need programming or coding skills to visualize your data using ChartExpo.

Like we said, how to add a secondary axis in Excel should never be among your worries in data storytelling. We hope we’ve delivered value on how you can alleviate the problem (above).

Sign up for a 7-day free trial today to access easy-to-interpret and visually appealing charts with secondary axes.

How much did you enjoy this article?

We will help your ad reach the right person, at the right time

PPC Signal

Your Data. Your Insights.

Actionable insights discovered for you. Now you can do more in less time.

PPCexpo Keyword Planner

Find the Perfect Keyword. Surprise Yourself.

PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.

PPC Audit

Free Google Ads Audit Report.

Frequent audits will help you optimize your PPC campaign for success.

ChartExpo PPC Charts

Picture a Thousand Numbers. See the Big Picture.

Visualizations give you the ability to instantly grasp the insights hidden in your numbers.

PPCexpo PPC Reports

Simple and Easy PPC Reporting. For Everyone.

Experience the new revolution in reporting … click your way to insights, don’t scroll.

Combinations Calculator

Do the Math.

Calculate the number of combinations in your PPC campaign. It may surprise you.

Insightful pay-per-click tips and tricks, delivered to your inbox weekly.

CTR Survey

ppc signal ad
chartexpo ad
ppc audit ad
keyword planner ad
120479

Related articles

next previous
Data Visualization8 min read

Top 10 Survey Design Best Practices for Actionable Feedback

Click here to learn the 10 survey design best practices for actionable feedback. Also, discover the three C's of survey design and how to analyze the data.

Data Visualization9 min read

Discover 5 Engaging Examples of Rating Scales in Excel

Click to learn 5 engaging examples of Rating Scales. Also, we’ll show you how to analyze Rating Scale data.

Data Visualization8 min read

How to Get Customer Feedback: A Quick Guide

Click to learn how to get customer feedback innovatively and faster. Also, we’ll show you how to analyze your customer feedback data.

Data Visualization8 min read

Analyze Survey data with Best NPS Survey Tool in Excel

Discover the best NPS survey tool and learn how to conduct an NPS survey. Click here to learn how to use ChartExpo to visualize your results.

Data Visualization8 min read

How to Analyze NPS Rating Data in Excel?

Learn everything you need to know about NPS rating; how to calculate NPS score and the best tools to analyze NPS survey data.

PPCexpo

  • Home
  • Tools
  • Pricing
  • Contact us
  • PPC Guide
  • Blog
  • Sitemap
  • © 2023 PPCexpo, all rights reserved.

Company

  • Contact us
  • Privacy policy
  • Security
  • Patent

Tools

  • PPC Signal
  • PPCexpo Keyword Planner
  • PPC Audit
  • ChartExpo™ PPC Charts
  • PPCexpo PPC Reports
  • Combinations Calculator

Quick Links

  • PPC Guide
  • PPC Signal Dashboard
  • PPC Reports Templates
  • ChartExpo™ for Google Sheets
  • ChartExpo™ for Microsoft Excel
  • PPCexpo Keyword Planner Google Chrome Extension

Charts

  • CSAT Score Survey Chart
  • Likert Scale Chart
  • Pareto Chart
  • Sankey Diagram

Category

  • PPC
  • SEM
  • SEO
  • SMM
  • Data Visualization
  • Others
Join our group

Benefits

  • Q&A on PPC advertising
  • Get expert advice
  • Great PPC discussions
  • Stay updated with PPC news
  • Quick support on tools
  • Discounts and special offers