Microsoft Excel’s chart functions help readers quickly visualise information and see insights buried within sheets of endless data. They can include bar charts, line and scatter graphs and many more.

Double Axis Graph 1

Normally a line or bar chart is sufficient enough to show off the data being analysed, helping to show trends, year on year differences, spikes and depressions. Sometimes however, there is need to create one single chart for two different, yet related, pieces of data. These graphs are called double axis or secondary axis graphs.

You may need this secondary axis graph for a number of reasons; however using the sample data below we are going to create a graph to show the quantity of impressions to a website over time, compared with the revenue over that same period of time.

Double Axis Graph 2

If we were to create a normal singular line graph for the impressions vs revenue the graph would look like the below. As you can see the amount of impressions is unidentifiable as the numbers are so low compared with the revenue.

Double Axis Graph 3

So now we will show you how to create a graph that looks like this…

Double Axis Graph 4

As can clearly be seen, there is quite a strong correlation between the amount of impressions and the revenue, with revenue being generated slightly after the initial impressions.

How to create this double axis graph.

  1. At the top of you toolbar select Insert, Line and click on the first line graph.Double Axis Graph 5
  2. Right click on the box that comes up and click on Select Data.Double Axis Graph 6
  3. Click in the Chart Data Range and whilst holding CTRL highlight the data that you want to include in the chart. In this case the impressions and Revenue columns. Take your finger off CTRL between selecting each column.Double Axis Graph 7
  4. Name your series by clicking on Series 1, Edit and changing Series Name.Double Axis Graph 8
  5. Select your horizontal Axis Labels by clicking edit.Double Axis Graph 9
  6. Then highlight the data you want as you horizontal axis. In this case it is the date in our Period column.Double Axis Graph 10
  7. You will then end up with a chart that looks like this…Double Axis Graph 3
  1. Now to add a secondary axis. Click on Layout and then the drop down menu to the left of the tool bar. Click on one of your series in this case “Revenue”.Double Axis Graph 11
  2. Over to the left underneath the drop down menu select Format Selection.Double Axis Graph 12
  3. Select Secondary Axis on the box that comes up.Double Axis Graph 13
  4. You will now have a much clearer graph that looks something like this.Double Axis Graph 14

 

LEAVE A REPLY


*