If you want to create a graph from pre-existing data, instead double-click the Excel document that contains the data to open it and proceed to the next section. 2 Click Blank workbook (PC) or Excel Workbook (Mac).
Up to Microsoft Excel 2003, there was a in-built Custom Chart Type called the 2-Axis Chart. This was a pretty useful chart type, which I used to display very small numbers and very large numbers – all on the same chart.
But it magically disappeared from Excel 2007, Excel 2010 & even Excel 2013. 2 Axis Chart in Microsoft Excel What is a 2 Axis Chart? The default Bar Chart of Excel has One X Axis (The Horizontal side), and One Y Axis (represented Vertically).
This is useful most of the time. However, once in a while, when you want to display 2 different sets of numbers in the same chart, and one set of numbers (Quantity) comprises of very small numbers, and the other set of numbers (Sales figures) are very large – in Thousands. If you plot a normal bar 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 Bar Chart. A 2 axis chart is slightly different from a normal, standard chart. It uses 2 Y Axis in the same chart. The one on the Left of the chart is used to display one scale (Small Numbers), and another Y Axis is added on the Right Side, which represents the (Large Numbers) in Thousands.
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. However, do note that the Bars 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.
Since the scale is different, both can be seen, and in this way, a useful 2 Axis chart is created easily in Microsoft Excel. Want to Improve Your Excel Skills? Learn the Key Features of Excel Quickly & Easily, by Joining the To Get Most out of Excel, Learn the If you wish to make a 2 Axis Chart in Microsoft Excel 2007 or Excel 2010 or Excel 2013, just follow this fairly simple process:. Select the Data to be plotted.You can use this.
Click Insert Column 2-D Column Chart. You will get a normal Bar Chart in Excel. Click on one of the bar charts. The entire series gets selected. Right Click, and select Format Data Series. From the Format Data Series Popup Menu, Choose Secondary Axis.
![How To Create Two Axis Chart In Excel For Mac How To Create Two Axis Chart In Excel For Mac](/uploads/1/2/5/3/125384373/775542992.png)
You will see that the selected data series has moved to the Secondary Axis. Format the chart to your liking. 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 Enjoy! Additional Useful Tips. (Video).
– Be a Power Analyst!. Anything else you’d like covered here? Do post a comment and let me know. Hope you enjoyed this Excel Tip. If you would like some more tips on Charts, Pivot Tables techniques, simply. Cheers, Vinai Prakash.
When using and working with two data sets that differ greatly in range it can be difficult to chart those values due to the larger range of one of your data sets. A classic example of this would be your monthly data and your YTD values for each month. When you put these together in a chart the monthly data is diminished by the much larger YTD values. In order to overcome this you can assign each data set an axis.
The default for all your data sets is the Primary axis, you have the option of assigning your second data set to the second axis which makes your chart readable. Below you will find the instructions on how to add a second axis to an Excel graph. If you have any comments or questions, please post them below. Note: I used Excel 2003 for this demonstration, but it should hold true for 97-2007. Graph without Second Axis The following steps were written assuming you have a chart in excel with more than one data set.
If you wish to view the step-by-step, click the pic tutorial icon - or you can follow the steps below. Select a point on the graph for the data set you want to put on the secondary axis.
Right-click and select Format Data Series 3. Click on the Axis tab and select the Secondary axis radio button 4. Your selected data set should now reside on the second axis of your chart. Graph with Second Axis Enabled.
Gilbert is a Microsoft MVP, a full-time blogger, and technology aficionado. When Gilbert is away from his bike and his iPad, he's busy writing technology how-to's from his home-office in Miami, Florida on the latest programs and gadgets he can get his hands on. He's locally known as 'the computer guy' and has spent the last 12 years helping family, friends, and GilsMethod.com visitors with their computer questions and problems. He was awarded the 2009 MVP award from Microsoft for his contributions in forums and blogs and is enjoying the new addition to his family.