{"id":45,"date":"2012-07-23T22:58:40","date_gmt":"2012-07-23T14:58:40","guid":{"rendered":"http:\/\/excelchamp.net\/?p=45"},"modified":"2022-07-11T06:27:43","modified_gmt":"2022-07-10T22:27:43","slug":"creating-a-two-axis-chart-in-excel-2010","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/creating-a-two-axis-chart-in-excel-2010\/","title":{"rendered":"Creating a Two Axis Chart in Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2016 & Microsoft Office 365"},"content":{"rendered":"

Up to Microsoft Excel 2003<\/strong>, there was a in-built\u00a0Custom Chart Type<\/strong> called the 2-Axis Chart<\/strong>. This was a pretty useful chart type, in which I used to display very small numbers and very large numbers – all on the same chart. You can see in this chart below, the numbers on the Primary Y Axis on the left are from 0 to 16. The numbers on the Secondary Y Axis (on the right side of the chart), are from 20,000 to 180,000.<\/p>\n

\"2<\/a>2 Axis Chart in Microsoft Excel<\/span><\/p>\n

But this 2 Axis chart type magically disappeared from Excel 2007, Excel 2010 & even Excel 2013<\/em>. So today, I will show you how to create a 2 Axis chart in any version of Excel<\/strong> <\/em>– whether you are still using Microsoft Excel 2007 or Microsoft 2010, or the latest Excel 2016, 2019 or Office 365 (Cloud version of Microsoft Office).<\/p>\n

What is a 2 Axis Chart?<\/strong><\/h2>\n

The default Bar Chart or a Column chart of Excel has One X Axis (The Horizontal side)<\/strong>, and One Y Axis (represented Vertically)<\/strong>. This is generally useful most of the time.<\/p>\n

However, once in a while, when you want to display 2 different sets of numbers in the same chart<\/strong>, and one set of numbers (Quantity<\/em>) comprises of very small numbers, and the other set of numbers (Sales figures<\/em>) are very large – \u00a0in Thousands.<\/em><\/p>\n

If you plot a normal Column chart, the Sales figures are so high that the bars are quite long, and the scale is set in Thousands. So the Quantity figures are too small to be even seen in the Column Chart.<\/p>\n

A 2 Axis chart is slightly different from a normal, standard Column Chart.<\/strong><\/p><\/blockquote>\n

The 2 Axis Column Chart uses TWO Y Axis in the same chart.<\/strong> The one on the Left of the chart is used to display one scale (Small Numbers)<\/em>, and another Y Axis is added on the Right Side, which represents the (Large Numbers) in Thousands.<\/em><\/p>\n

In this way, both small numbers and very large numbers are seen in the same chart – using both the Primary Axis and the Secondary Axis.<\/p>\n

However, do note that the Columns of the Chart will overlap each other, and it will be difficult to see one set of values. To overcome this situation, we convert one of the bars into a Line Chart.<\/p>\n

In this way, even if the scale is different, both axis can be seen clearly, and a useful 2 Axis chart is created easily in Microsoft Excel.<\/strong><\/p><\/blockquote>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Want to Improve Your Excel Skills?<\/strong><\/span><\/p>

Learn the Key Features of Excel Quickly & Easily, by <\/span>Joining the
Online Training<\/strong> on <\/u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p>

To Get Most out of Excel, Learn the\u00a0 Pivot Table techniques in our
Pivot Table Masterclass Training<\/a><\/u><\/b>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n

How To Make a 2 Axis Chart in Excel 2007 to Excel 2013<\/h2>\n

If you wish to make a 2 Axis Chart in Microsoft Excel 2007 or Excel 2010 or Excel 2013, \u00a0just follow this \u00a0fairly simple process:<\/strong><\/p>\n

    \n
  1. Select the Data to be plotted. You can use this Example Worksheet to practice creating the 2 Axis Chart<\/a>.<\/li>\n
  2. Click Insert<\/strong> <\/em>> Column<\/strong> <\/em>> 2-D Column Chart<\/strong><\/em>. You will get a normal Bar Chart in Excel.<\/li>\n
  3. Click<\/strong> on one of the bar charts. The entire series gets selected.<\/li>\n
  4. Right Click<\/strong>, and select Format Data Series<\/strong><\/em>.<\/li>\n
  5. From the Format Data Series Popup Menu<\/strong>, Choose Secondary Axis<\/strong><\/em>.<\/li>\n
  6. You will see that the selected data series has moved to the Secondary Axis.<\/li>\n
  7. Format the chart to your liking.<\/li>\n<\/ol>\n

    You can have a beautiful looking chart, displaying data on 2 axis – the Y axis is listed on both sides. And it hardly takes a minute to build…\u00a0Enjoy!<\/p>\n

    How To Make a 2 Axis Chart in Excel 2016, Excel 2019 or Microsoft Office 365<\/h2>\n

    For the newer versions of Microsoft Excel, the steps are slightly different.<\/p>\n

    STEP 1:<\/strong> Select the Data to be plotted in the chart.\u00a0\u00a0You can use this Example Worksheet to practice creating the 2 Axis Chart<\/a>.<\/p>\n

    STEP 2:<\/strong> Click on Insert > Recommended Charts<\/strong>. Choose the second Tab in the popup, All Charts<\/strong>.<\/p>\n

    \"Inserting
    Inserting Recommended Chart in Excel<\/figcaption><\/figure>\n

    STEP 3:<\/strong> Go to the bottom of the Chart List, and select the Combo Chart.<\/strong><\/p>\n

    \"Select<\/p>\n

    A combo chart is created. We can’t see both quantity and Sales, as the sales figures are too high. So we need to modify this.<\/p>\n

    STEP 4:<\/strong> What we really want is to move Sales on the Secondary Axis.<\/strong> So check the checkbox\u00a0 next to the Quantity.<\/strong><\/p>\n

    \"Checkbox<\/p>\n

    Sales moves to the secondary axis<\/em>, and is visible.<\/p>\n

    You can see that Quantity Sold is in Columns<\/em> (showing as vertical bars), and Sales is displayed in a Line Chart<\/em>.<\/strong><\/p>\n

    \"2
    2 Axis Combo Chart in Microsoft Office 365, Excel 2016 & Excel 2019<\/figcaption><\/figure>\n

    STEP 6:<\/strong> Now simply add an appropriate Chart Title<\/strong>.<\/p>\n

    Your 2 Axis Chart in Excel is ready for Microsoft 365<\/strong>. The same technique works for Excel 2016 & Excel 2019 also.<\/p>\n

    Additional Useful Tips & Tricks on Excel at our Website<\/strong><\/h2>\n