• 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 Make a Graph with Two Y-Axis in Excel? Complete Guide

If a picture says a thousand words, a chart says ten thousand.

In the digital age, data is created at an increasing rate. Thus, data visualizations and charts are no longer just tools used in business meetings.

How to Make A Graph With Two Y-Axis in Excel?

They are practical and necessary tools for conveying complex ideas and concepts without words or raw numbers. This is why data visualizations and charts are everywhere now.

In this discussion, we’ll look at various double y-axis charts that can be used for marketing. For each chart type, we’ll answer the following questions:

  • Benefits Of Using Double Y-Axis Chart
  • How to Make a Graph With Two Y-Axis in Excel? Step by Step Guide with Examples
  • How To Tell Your Story With A Chart
  • How Can You Use Charts To Help Evolve Your Marketing Campaign?

We’ll also discuss how to make a graph with two Y-axis in Excel but first learn about the benefits of using a Double Y-Axis chart. Let’s begin!

Benefits of Using Double Y-Axis Chart

  • If you know how to make a graph with two Y-axis in Excel, you can use it to compare different aspects of your data.
  • Tracking two variables at once supports management because of how many metrics are involved in your campaigns.
  • With the double Y-axis, it is easy to illustrate a relationship between two metrics, even when those metrics have different magnitudes or scales of measurement.
  • Two Y-axis in one chart allows you to show double the information. This means you can get more value out of a single chart.

Here’s an example of a double Y-axis chart:

How to Make A Graph With Two Y-Axis in Excel?

You can also create such chart by installing add-in in your spreadsheet app by clicking below.

In the chart above, two different KPIs are being compared. Even though each data has dramatically different scales, the double Y-axis can express both at the same time.

This allows you to compare data in a completely different way. Many different charts use this double-axis design. These various visualizations can lead to new discoveries.

Part 2: How to Make a Graph With Two Y-Axis in Excel? Step by Step Guide with Examples

This part of the guide teaches you how to create charts with 2 Y-axis in Excel using ChartExpo add-on and how each double Y-axis chart works.

Specifically, we’ll cover these 4 charts:

  1. Dual Axis Line Chart
  2. Multi Axis Line Chart
  3. Pareto Vertical Chart
  4. The Component Trend Chart

In this section, you’ll also learn about different chart examples available in Excel thanks to the ChartExpo add-in.

This is a free as trial add-in that expands Excel’s existing charting options with around 80 new selections. Many of the visualizations included in ChartExpo are designed specifically with marketers in mind.

ChartExpo is the best tool to show your data in ways that immediately bring trends and insights into vision. Insights are the driving force behind change and growth in the business world.

1. Dual Axis Line Chart

This section will outline how to make a graph with two Y-axis in Excel using the ChartExpo add-in. The Dual Axis Line Chart is a prime example of why two axis are better than one!

As discussed earlier, the Dual Axis Line Chart is great for comparing two data sets with very different ranges. This frequently happens in marketing. Imagine comparing your clicks to your conversions. You may have 1,000 clicks and only a handful of conversions.

With the Dual Axis Line Chart, you can compare each trend line’s relative values, despite this imbalance in data ranges.

When To Use The Dual Axis Line Chart?

To reiterate, two axis allow you to compare data with two very different ranges. This enables you to illustrate the relationship between these two variables without allowing these different ranges to skew the data.

There are many metrics in PPC marketing that share relationships, yet have very different data ranges, such as:

  • Impressions: Clicks
  • Clicks: Conversions
  • Impressions: Conversions
  • CPC(Cost per click): CTR (Clickthorugh Rate)
  • Conversions: Conversion Value

Comparing these metrics will help you better understand your campaigns. The Dual Axis Line Chart allows you to include each data set in one chart.

Preparing The Data For A Dual Axis Line Chart

To make any graph with two Y-axis in Excel, you need to start with a spreadsheet. ChartExpo will then use this sheet to fill in the blanks of the chart.

For example, Wilma wants to compare the CPC to CTR for the last 24 hours in her campaign.

To do this, she prepared the table as shown below: You must know that CPC is in dollars and CTR is in percentage.

Hour of Day CPC CTR
0 22.23 9.1
1 19.87 8.2
2 18.22 7.6
3 27.67 7.3
4 22.7 8.5
5 15.76 8.4
6 16.85 8.6
7 17.54 9.2
8 16.14 8.6
9 16.33 8.7
10 16.43 8.9
11 16.34 8.5
12 16.21 8.7
13 16.52 8.9
14 16.42 8.9
15 16.17 9
16 15.57 8.6
17 16.48 9
18 16.34 8.8
19 14.99 8.9
20 17.26 9.8
21 13.67 8.9
22 12.32 9.3
23 11.28 8.6

Creating A Dual Axis Line Chart With ChartExpo:

To get started, Wilma will click on INSERT from the top toolbar in Excel.

How to Make A Graph With Two Y-Axis in Excel?

From the resulting toolbar, she’ll click the down arrow next to My Apps. Then, the ChartExpo™ for Excel option will appear.

How to Make A Graph With Two Y-Axis in Excel?

It’s important to note that these steps assume you have already downloaded the ChartExpo add-in for Excel.

If you haven’t already done this, click here to download the ChartExpo add-in for Excel.

Once you click on the ChartExpo option, it will open the add-in. The first screen you’ll see gives you the opportunity to find lots of charts available.

How to Make A Graph With Two Y-Axis in Excel?

There is also a search bar that you can use to look up any visualization you want to use directly. In this case let’s find dual axis line chart.

How to Make A Graph With Two Y-Axis in Excel?

You can click on that, you can paste the data table in the Excel sheet Once you’ve selected the Dual Axis Line Chart, you want to press Create Chart From Selection. This will use your spreadsheet to produce a chart.

How to Make A Graph With Two Y-Axis in Excel?

Based on the example spreadsheet of Wilma’s data, here is what the visualization would first look like:

How to Make A Graph With Two Y-Axis in Excel?

But above chart is not showing the data provide in the table reason is this visualization by default is showing percentag of data. There are few properties which you will tweak to make the chart awesome.

How to Make A Graph With Two Y-Axis in Excel?

You can select Value Based and click on Apply button to see the actual data.

How to Make A Graph With Two Y-Axis in Excel?

Next step is to put the lables and on each axis, put headings and provide dollar signe and pecentage as prefix and post fix on the axis. All these properties you can find by click on Edit Chart button.

How to Make A Graph With Two Y-Axis in Excel?

You can also create the visualization on your data by installing ChartExpo library for your desire tool.

What Insights Does This Chart Give?

The first thing to note with this chart is how similar the two trend lines are. The Dual Axis Line Chart immediately shows Wilma the relationship these two metrics share.

From there, Wilma can begin looking hour-by-hour for interesting trends or anomalies.

The big spike in CPC around hour 3 is the most obvious change in the data. This is also the point where CTR is at its lowest. This could signal a hyper-competitive type slot where costs are high and performance is lacking.

Wilma may want to pause her campaign for this period!

For the rest of the day, the data remains pretty normal. Around hour 20, there is a notable increase in both CPC and CTR. This may be a time that Wilma wants to investigate further. Even though her clicks are costing slightly more, she sees a promising rise in CTR.

2. Multi Axis Line Chart

A Dual Axis Line Chart allows you to compare two values, but a Multi-Axis Line Chart gives you the opportunity to compare more than two.

This means you are comparing 2 or more values with differing scales. Thus, each data set needs its own Y-axis.

Since this is a line chart, it’s helpful to compare these differing values over a stretch of time.

When To Use The Multi-Axis Line Chart?

In marketing, there are a lot of metrics that are relative to one another.

For example, if your ad doubles its impressions or ad views, you should see a similar spike in clicks. After all, more people seeing your ads means more potential clicks.

In turn, this also creates more conversions. If 100 people click your ad and 5 converts, then it stands to reason that 1,000 clicks will generate approximately 50 conversions.

However, each metric has a very different scale. You may have 2,000 impressions, 100 clicks, and only 5 conversions. The Multi Axis Line Chart makes it possible to graph all of this data in a single visualization.

Preparing The Data For A Multi Axis Line Chart

Daphne is a marketing manager who wants to see how her ads perform in terms of impressions, clicks, and conversions.

Date Clicks Impressions Conversions
5/1/2022 1483 18766 55
5/2/2022 1313 18788 57
5/3/2022 1345 18743 60
5/4/2022 1256 18788 63
5/5/2022 1304 16406 59
5/6/2022 1407 17765 60
5/7/2022 1498 20532 65
5/8/2022 1597 20016 58
5/9/2022 1587 20122 61
5/10/2022 1483 20125 64
5/11/2022 1565 23783 59
5/12/2022 1587 22942 57
5/13/2022 1599 23127 70
5/14/2022 1620 24548 78
5/15/2022 1788 23448 80
5/16/2022 1768 23408 91
5/17/2022 1987 25473 89
5/18/2022 1939 24959 81
5/19/2022 1987 23710 86
5/20/2022 1964 24221 98
5/21/2022 1740 23317 89
5/22/2022 1748 24431 85
5/23/2022 1876 23785 79
5/24/2022 1826 22247 83
5/25/2022 1920 23851 83
5/26/2022 1886 24875 90
5/27/2022 1769 24015 94
5/28/2022 1869 25689 104
5/29/2022 1823 24416 99
5/30/2022 1899 25874 114
5/31/2022 1924 26146 98

So in the same way as previously steps are shown to use ChartExpo. We will also use in the same way but this time will select Multiaxis line chart and it will appear as shown below:

How to Make A Graph With Two Y-Axis in Excel?

Final look will be like this:

How to Make A Graph With Two Y-Axis in Excel?

You can also create this chart with your own data by installing this library by clicking below:

What Insights Does This Chart Give?

With this data visualization, Daphne can see how well her ads perform (or how well they aren’t performing) at each stage of the ad process.

Because of these three metrics’ relative nature, it is normal that they follow a similar trend pattern. It would be unlikely that conversions would spike when clicks and impressions are at their lowest.

The real exciting point in this example Multi Axis Line Chart is where the impressions and clicks trend lines intersect. This reflects a period of good CTR and not-so-good CTR.

Daphne may want to investigate this period further to see what changed.

3. Pareto Vertical Chart

The Pareto Vertical Chart is built on the idea that the majority of results come from a small minority of your efforts. In PPC, for example, most of your clicks and conversions will come from only a handful of keywords.

This is also known as the 80-20 rule — 80% of outputs are created by 20% of inputs. (It is not always a perfect 80-20 distribution).

Here’s an example of a Pareto Vertical Chart showing how a budget is being spent across different keywords. Here is the data below:

Keyword Consumed Budget
mobile 510 540
smartphone 545 550
phones 99 115
mobile phones 533 572
cellphones 85 93
unlock phone 63 88
mobile shop 485 497
free phones 80 115
prepaid phones 470 489
cheap phones 67 87

By creating this chart with ChartExpo following look will appear.

How to Make A Graph With Two Y-Axis in Excel?

You can create the above chart by install ChartExpo libray by clicking below for your desrire tool.

On the surface, the Pareto Vertical Chart looks like a typical bar chart. The primary difference is the cascading line across the bars. This represents the cumulative total of each item.

In this example, the line shows how much each keyword contributes to the total budget. As the most expensive keyword, “mobile” spends 27.1% of the total budget. Meanwhile, the smaller bars represent just ~5% of the budget.

With this chart, you can see how much each small piece contributes to the larger whole.

When To Use The Pareto Vertical Chart?

The best way to use a Pareto Vertical Chart is to identify vital versus useful opportunities in your campaigns.

Vital opportunities are the 20% of inputs that create the majority of your results.

Useful opportunities are the remaining 80% of inputs that, while not as vital, still produce some value.

When you can identify the components of your Google Ads account generating the majority of your results, you can optimize your strategies for these vital few components.

This ensures that you’re spending your time and budget on the strategies, keywords, campaigns, ad groups, etc., with the highest potential. This is a great way to maximize your productivity as a manager.

What Insight Does This Chart Give?

Every campaign involves multiple keywords. On the surface, it isn’t always easy to gauge each one’s performance in terms of how it contributes to the whole. This is true for budget, clicks, conversions and almost any other metric.

In short, you know that some keywords are better than others. The Vertical Pareto Chart shows how much better one keyword is to the next. This chart is also great because it lists your keywords in order of significance.

This allows you to identify your most and least impactful selections immediately. Then, you can optimize your bids accordingly.

4. The Component Trend Chart

In marketing, you have many examples of multiple metrics or data points contributing to a larger whole.

This is not unlike what we saw with the vertical Pareto Chart, where multiple keywords made up the total budget for that campaign.

This parts-and-whole relationship is prevalent in PPC. There are times where the Pareto Chart isn’t the best way to display the information. An alternative method is the Component Trend Chart.

This chart is handy when looking at how a change to one component affects the whole.

When To Use The Component Trend Chart?

The best use for the Component Trend Chart is to analyze Quality Scores.

When managing a campaign, paying attention to Quality Scores is absolutely vital to your campaigns’ success and performance.

High Quality Scores can improve your ad ranks, lower your costs, improve your clickthrough rates (CTR) and create an overall healthier Google Ads account.

Google uses multiple factors to determine Quality Scores. Three of the most significant factors are landing page experience, ad relevance and expected CTR.

The Component Trend Chart is helpful to see how changes in these areas could positively or negatively affect your overall quality score.

Preparing The Data For A Component Trend Chart

In this example, Oliver is a manager that wants to improve his Quality Scores. He understands the significant impact that improving these ratings will have on his overall account performance.

Throughout two months, Oliver works hard to improve his landing page experience, ad relevance and CTR. He tracks his quality ratings for each category throughout this period and enters the data into a spreadsheet.

This is what Oliver’s data looks like:

Date Relevancy Status Quality Score
5/1/2022 Ad Relevance Above Average 4.9
5/1/2022 Ad Relevance Average 4.3
5/1/2022 Ad Relevance Below Average 3.1
5/1/2022 Exp. CTR Above Average 5.6
5/1/2022 Exp. CTR Average 3.6
5/1/2022 Exp. CTR Below Average 1.8
5/1/2022 Landing Page Exper. Average 5.8
5/1/2022 Landing Page Exper. Below Average 3.7
5/2/2022 Ad Relevance Above Average 4.9
5/2/2022 Ad Relevance Average 4.3
5/2/2022 Ad Relevance Below Average 3.1
5/2/2022 Exp. CTR Above Average 5.7
5/2/2022 Exp. CTR Average 3.6
5/2/2022 Exp. CTR Below Average 1.8
5/2/2022 Landing Page Exper. Average 5.9
5/2/2022 Landing Page Exper. Below Average 3.7
5/3/2022 Ad Relevance Above Average 5.1
5/3/2022 Ad Relevance Average 4.3
5/3/2022 Ad Relevance Below Average 3.1
5/3/2022 Exp. CTR Above Average 5.7
5/3/2022 Exp. CTR Average 3.6
5/3/2022 Exp. CTR Below Average 1.8
5/3/2022 Landing Page Exper. Average 6.4
5/3/2022 Landing Page Exper. Below Average 3.7
5/4/2022 Ad Relevance Above Average 5.1
5/4/2022 Ad Relevance Average 4.4
5/4/2022 Ad Relevance Below Average 3.1
5/4/2022 Exp. CTR Above Average 5.8
5/4/2022 Exp. CTR Average 3.6
5/4/2022 Exp. CTR Below Average 1.8
5/4/2022 Landing Page Exper. Average 6.3
5/4/2022 Landing Page Exper. Below Average 3.8
5/5/2022 Ad Relevance Above Average 5.1
5/5/2022 Ad Relevance Average 4.5
5/5/2022 Ad Relevance Below Average 3.2
5/5/2022 Exp. CTR Above Average 5.7
5/5/2022 Exp. CTR Average 3.6
5/5/2022 Exp. CTR Below Average 1.8
5/5/2022 Landing Page Exper. Above Average 6
5/5/2022 Landing Page Exper. Average 6.4
5/5/2022 Landing Page Exper. Below Average 3.8
5/6/2022 Ad Relevance Above Average 5.2
5/6/2022 Ad Relevance Average 4.6
5/6/2022 Ad Relevance Below Average 3.2
5/6/2022 Exp. CTR Above Average 5.7
5/6/2022 Exp. CTR Average 3.6
5/6/2022 Exp. CTR Below Average 1.7
5/6/2022 Landing Page Exper. Above Average 6
5/6/2022 Landing Page Exper. Average 6.8
5/6/2022 Landing Page Exper. Below Average 3.8
5/7/2022 Ad Relevance Above Average 5.4
5/7/2022 Ad Relevance Average 4.7
5/7/2022 Ad Relevance Below Average 3.3
5/7/2022 Exp. CTR Above Average 5.7
5/7/2022 Exp. CTR Average 3.6
5/7/2022 Exp. CTR Below Average 1.7
5/7/2022 Landing Page Exper. Above Average 7
5/7/2022 Landing Page Exper. Average 6.7
5/7/2022 Landing Page Exper. Below Average 3.9
5/8/2022 Ad Relevance Above Average 5.6
5/8/2022 Ad Relevance Average 4.7
5/8/2022 Ad Relevance Below Average 3.4
5/8/2022 Exp. CTR Above Average 5.7
5/8/2022 Exp. CTR Average 3.6
5/8/2022 Exp. CTR Below Average 1.6
5/8/2022 Landing Page Exper. Above Average 7.3
5/8/2022 Landing Page Exper. Average 6.6
5/8/2022 Landing Page Exper. Below Average 4
5/9/2022 Ad Relevance Above Average 5.6
5/9/2022 Ad Relevance Average 4.9
5/9/2022 Ad Relevance Below Average 3.4
5/9/2022 Exp. CTR Above Average 5.7
5/9/2022 Exp. CTR Average 3.6
5/9/2022 Exp. CTR Below Average 1.6
5/9/2022 Landing Page Exper. Above Average 7.3
5/9/2022 Landing Page Exper. Average 6.4
5/9/2022 Landing Page Exper. Below Average 4.1
5/10/2022 Ad Relevance Above Average 5.6
5/10/2022 Ad Relevance Average 4.9
5/10/2022 Ad Relevance Below Average 3.5
5/10/2022 Exp. CTR Above Average 5.7
5/10/2022 Exp. CTR Average 3.7
5/10/2022 Exp. CTR Below Average 1.6
5/10/2022 Landing Page Exper. Above Average 7.3
5/10/2022 Landing Page Exper. Average 6.3
5/10/2022 Landing Page Exper. Below Average 4.1
5/11/2022 Ad Relevance Above Average 5.6
5/11/2022 Ad Relevance Average 4.9
5/11/2022 Ad Relevance Below Average 3.5
5/11/2022 Exp. CTR Above Average 5.7
5/11/2022 Exp. CTR Average 3.7
5/11/2022 Exp. CTR Below Average 1.6
5/11/2022 Landing Page Exper. Above Average 7.3
5/11/2022 Landing Page Exper. Average 6.3
5/11/2022 Landing Page Exper. Below Average 4.1
5/12/2022 Ad Relevance Above Average 5.6
5/12/2022 Ad Relevance Average 5
5/12/2022 Ad Relevance Below Average 3.5
5/12/2022 Exp. CTR Above Average 5.7
5/12/2022 Exp. CTR Average 3.7
5/12/2022 Exp. CTR Below Average 1.6
5/12/2022 Landing Page Exper. Above Average 7.3
5/12/2022 Landing Page Exper. Average 6.5
5/12/2022 Landing Page Exper. Below Average 4.1
5/13/2022 Ad Relevance Above Average 5.7
5/13/2022 Ad Relevance Average 5
5/13/2022 Ad Relevance Below Average 3.5
5/13/2022 Exp. CTR Above Average 5.7
5/13/2022 Exp. CTR Average 3.7
5/13/2022 Exp. CTR Below Average 1.6
5/13/2022 Landing Page Exper. Above Average 7.3
5/13/2022 Landing Page Exper. Average 6.3
5/13/2022 Landing Page Exper. Below Average 4.2
5/14/2022 Ad Relevance Above Average 5.7
5/14/2022 Ad Relevance Average 5
5/14/2022 Ad Relevance Below Average 3.5
5/14/2022 Exp. CTR Above Average 5.8
5/14/2022 Exp. CTR Average 3.7
5/14/2022 Exp. CTR Below Average 1.5
5/14/2022 Landing Page Exper. Above Average 7.3
5/14/2022 Landing Page Exper. Average 6.4
5/14/2022 Landing Page Exper. Below Average 4.1
5/15/2022 Ad Relevance Above Average 5.7
5/15/2022 Ad Relevance Average 5
5/15/2022 Ad Relevance Below Average 3.5
5/15/2022 Exp. CTR Above Average 5.7
5/15/2022 Exp. CTR Average 3.6
5/15/2022 Exp. CTR Below Average 1.5
5/15/2022 Landing Page Exper. Above Average 7
5/15/2022 Landing Page Exper. Average 6.4
5/15/2022 Landing Page Exper. Below Average 4.1
5/16/2022 Ad Relevance Above Average 5.7
5/16/2022 Ad Relevance Average 5
5/16/2022 Ad Relevance Below Average 3.5
5/16/2022 Exp. CTR Above Average 5.7
5/16/2022 Exp. CTR Average 3.6
5/16/2022 Exp. CTR Below Average 1.5
5/16/2022 Landing Page Exper. Above Average 7
5/16/2022 Landing Page Exper. Average 6.4
5/16/2022 Landing Page Exper. Below Average 4.1
5/17/2022 Ad Relevance Above Average 5.7
5/17/2022 Ad Relevance Average 5
5/17/2022 Ad Relevance Below Average 3.5
5/17/2022 Exp. CTR Above Average 5.7
5/17/2022 Exp. CTR Average 3.6
5/17/2022 Exp. CTR Below Average 1.5
5/17/2022 Landing Page Exper. Above Average 7
5/17/2022 Landing Page Exper. Average 6.4
5/17/2022 Landing Page Exper. Below Average 4.2
5/18/2022 Ad Relevance Above Average 5.8
5/18/2022 Ad Relevance Average 5
5/18/2022 Ad Relevance Below Average 3.6
5/18/2022 Exp. CTR Above Average 5.7
5/18/2022 Exp. CTR Average 3.6
5/18/2022 Exp. CTR Below Average 1.5
5/18/2022 Landing Page Exper. Above Average 7
5/18/2022 Landing Page Exper. Average 6.4
5/18/2022 Landing Page Exper. Below Average 4.2
5/19/2022 Ad Relevance Above Average 5.8
5/19/2022 Ad Relevance Average 5
5/19/2022 Ad Relevance Below Average 3.6
5/19/2022 Exp. CTR Above Average 5.7
5/19/2022 Exp. CTR Average 3.6
5/19/2022 Exp. CTR Below Average 1.5
5/19/2022 Landing Page Exper. Above Average 7
5/19/2022 Landing Page Exper. Average 6.4
5/19/2022 Landing Page Exper. Below Average 4.2
5/20/2022 Ad Relevance Above Average 5.8
5/20/2022 Ad Relevance Average 5
5/20/2022 Ad Relevance Below Average 3.6
5/20/2022 Exp. CTR Above Average 5.7
5/20/2022 Exp. CTR Average 3.6
5/20/2022 Exp. CTR Below Average 1.5
5/20/2022 Landing Page Exper. Above Average 7
5/20/2022 Landing Page Exper. Average 6.4
5/20/2022 Landing Page Exper. Below Average 4.2
5/21/2022 Ad Relevance Above Average 5.8
5/21/2022 Ad Relevance Average 5
5/21/2022 Ad Relevance Below Average 3.6
5/21/2022 Exp. CTR Above Average 5.7
5/21/2022 Exp. CTR Average 3.6
5/21/2022 Exp. CTR Below Average 1.5
5/21/2022 Landing Page Exper. Above Average 7
5/21/2022 Landing Page Exper. Average 6.3
5/21/2022 Landing Page Exper. Below Average 4.2
5/22/2022 Ad Relevance Above Average 5.8
5/22/2022 Ad Relevance Average 5.1
5/22/2022 Ad Relevance Below Average 3.7
5/22/2022 Exp. CTR Above Average 5.7
5/22/2022 Exp. CTR Average 3.6
5/22/2022 Exp. CTR Below Average 1.5
5/22/2022 Landing Page Exper. Above Average 7
5/22/2022 Landing Page Exper. Average 6.3
5/22/2022 Landing Page Exper. Below Average 4.2
5/23/2022 Ad Relevance Above Average 5.8
5/23/2022 Ad Relevance Average 5.1
5/23/2022 Ad Relevance Below Average 3.7
5/23/2022 Exp. CTR Above Average 5.7
5/23/2022 Exp. CTR Average 3.6
5/23/2022 Exp. CTR Below Average 1.5
5/23/2022 Landing Page Exper. Above Average 7
5/23/2022 Landing Page Exper. Average 6.3
5/23/2022 Landing Page Exper. Below Average 4.3
5/24/2022 Ad Relevance Above Average 5.8
5/24/2022 Ad Relevance Average 5.1
5/24/2022 Ad Relevance Below Average 3.7
5/24/2022 Exp. CTR Above Average 5.7
5/24/2022 Exp. CTR Average 3.6
5/24/2022 Exp. CTR Below Average 1.5
5/24/2022 Landing Page Exper. Above Average 7
5/24/2022 Landing Page Exper. Average 6.3
5/24/2022 Landing Page Exper. Below Average 4.3
5/25/2022 Ad Relevance Above Average 5.8
5/25/2022 Ad Relevance Average 5.2
5/25/2022 Ad Relevance Below Average 3.7
5/25/2022 Exp. CTR Above Average 5.7
5/25/2022 Exp. CTR Average 3.6
5/25/2022 Exp. CTR Below Average 1.5
5/25/2022 Landing Page Exper. Above Average 7
5/25/2022 Landing Page Exper. Average 6.3
5/25/2022 Landing Page Exper. Below Average 4.3
5/26/2022 Ad Relevance Above Average 5.8
5/26/2022 Ad Relevance Average 5.2
5/26/2022 Ad Relevance Below Average 3.6
5/26/2022 Exp. CTR Above Average 5.7
5/26/2022 Exp. CTR Average 3.6
5/26/2022 Exp. CTR Below Average 1.5
5/26/2022 Landing Page Exper. Above Average 7
5/26/2022 Landing Page Exper. Average 6.3
5/26/2022 Landing Page Exper. Below Average 4.2
5/27/2022 Ad Relevance Above Average 5.8
5/27/2022 Ad Relevance Average 5.1
5/27/2022 Ad Relevance Below Average 3.7
5/27/2022 Exp. CTR Above Average 5.7
5/27/2022 Exp. CTR Average 3.6
5/27/2022 Exp. CTR Below Average 1.5
5/27/2022 Landing Page Exper. Above Average 7
5/27/2022 Landing Page Exper. Average 6.3
5/27/2022 Landing Page Exper. Below Average 4.2
5/28/2022 Ad Relevance Above Average 5.9
5/28/2022 Ad Relevance Average 5.1
5/28/2022 Ad Relevance Below Average 3.7
5/28/2022 Exp. CTR Above Average 5.7
5/28/2022 Exp. CTR Average 3.6
5/28/2022 Exp. CTR Below Average 1.5
5/28/2022 Landing Page Exper. Above Average 7
5/28/2022 Landing Page Exper. Average 6.3
5/28/2022 Landing Page Exper. Below Average 4.3
5/29/2022 Ad Relevance Above Average 5.8
5/29/2022 Ad Relevance Average 5.1
5/29/2022 Ad Relevance Below Average 3.7
5/29/2022 Exp. CTR Above Average 5.7
5/29/2022 Exp. CTR Average 3.6
5/29/2022 Exp. CTR Below Average 1.5
5/29/2022 Landing Page Exper. Above Average 7
5/29/2022 Landing Page Exper. Average 6.3
5/29/2022 Landing Page Exper. Below Average 4.3
5/30/2022 Ad Relevance Above Average 5.8
5/30/2022 Ad Relevance Average 5.1
5/30/2022 Ad Relevance Below Average 3.7
5/30/2022 Exp. CTR Above Average 5.7
5/30/2022 Exp. CTR Average 3.6
5/30/2022 Exp. CTR Below Average 1.5
5/30/2022 Landing Page Exper. Above Average 7
5/30/2022 Landing Page Exper. Average 6.3
5/30/2022 Landing Page Exper. Below Average 4.3
5/31/2022 Ad Relevance Above Average 5.8
5/31/2022 Ad Relevance Average 5.1
5/31/2022 Ad Relevance Below Average 3.7
5/31/2022 Exp. CTR Above Average 5.7
5/31/2022 Exp. CTR Average 3.6
5/31/2022 Exp. CTR Below Average 1.5
5/31/2022 Landing Page Exper. Above Average 7
5/31/2022 Landing Page Exper. Average 6.3
5/31/2022 Landing Page Exper. Below Average 4.3

This type of chart looks at data over a specified period. In column A, Oliver will put “Date” information for each data point.

Columns B and C are called ‘SubTopic 1’ and ‘Subtopic 2.’ The first SubTopic includes Ad Relevance, Expected CTR and Landing Page Experience, while the second deals with the rating scores (below average, average or above average.)

Finally, Column D shows the actual rating scores.

Creating A Component Trend Chart With ChartExpo

Again, you’ll start by accessing the ChartExpo tool in the top bar of Excel. This time you will select Components Trend Chart from the list. You will select the data and click on Create Chart from Selection to see the results as shown below.

How to Make A Graph With Two Y-Axis in Excel?

You can try this chart by ChartExpo for your data as well. Just click on below link to install for your desire tool.

What Insight Does This Chart Give?

With this Component Trend Chart, Oliver can accurately see how each change he made to ad relevance, expected CTR and landing page experience influenced his higher Quality Scores.

Ad relevance was a weak point for Oliver’s campaign. It started with a Below Average rating. Then, around Week03, Oliver improved this component, which resulted in a slight increase in Quality Score.

With ad relevance improved, Oliver worked on landing page experience in Week05. This created another uptick in Quality Score. Shortly after, he increased his expected CTR rating.

At the close of the 9 weeks, Oliver has a high, 9/10 Quality Score for his campaign. Looking at the Component Trend Chart, it’s evident that increasing ad relevance again is the next step. This will give Oliver’s campaign the extra push to get that perfect score!

How to Tell Your Story With a Chart?

The Internet has brought to view many informative, artistic, and entertaining visualizations.

As a result, audiences are more engaged and familiar with visual depictions of data than ever before. They are effective communication tools to be used internally and externally.

The challenge facing marketers is choosing the correct visualization to express data in the best way possible.

There are many different types of charts available to marketers. If you don’t choose the right one for the job, it may not effectively communicate the information.

Charts can provide a lot of value. Not only do they display the data, but they also help you see relationships between different numbers. This invites further interest or questions into the topic and deeper exploration.

Before making your chart, start by asking a question. What are you trying to prove or discover through visualization? Answering these questions will help you select the right chart to display your data.

When making your chart, simplicity is best. It’s not about impressing the viewer with your charting skills. It’s about telling the story of your data through a chart.

Remember, the goal of your visualization is to simplify the complex nature of the raw data. If you use an overly complicated chart to do this, you’ll defeat the purpose. How can you tell the story of your data using the least amount of chart objects?

You do not want to bombard your audience with too many unnecessary charting elements. These extra details distract from the intended purpose of your chart.

When you use a chart effectively, your data is brought to life. You and your audiences will see the insights right away.

ChartExpo allows you to preview how your data looks in different charts. This is an excellent feature for determining the best visualization for your data.

How Can You Use Charts To Help Evolve Your Marketing Campaign?

Data can be difficult to analyze without the assistance of visualization. There are several different metrics that each impact your performance in various ways.

To make it even more challenging, these metrics are constantly changing.

When you put the data into a chart, it is much easier to track and interpret changes. It’s not just about making the data look good; it’s about making it easier to analyze and understand.

Once you can see all of your data points in a chart, you can make better management decisions. You’ll see valuable correlations in your data and identify potentially risky outliers.

Wrap Up:

As a marketer, you have to make many decisions and you don’t have a lot of time to make them. If you wait too long, you could be missing out on valuable ways to improve performance.

Learning how to make a graph with two Y-axis in Excel is the first step in becoming a more productive marketer. With two axis, you’re able to compare and contrast multiple values in the same chart.

ChartExpo charts are already powerful tools that can help you make quick sense of your data. By adding an extra axis, you can pack even more value into every visualization you create.

ChartExpo transforms your raw data into stunning visualizations. With some of the best charts added to Excel, you’ll be able to see deeper insights in your data.

Deeper insights mean a superior competitive advantage!

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
113904

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