If you do not find a Chart with secondary axis, you can manually add a secondary axis by following the steps below.ġ. Manually Add Secondary Axis to Chart in Excel Click on OK to close the dialogue box and you will end up with an Excel Chart having a primary and secondary axis.Īs you can see in above image, adding a Secondary Axis has led to a better representation of both Monthly Sales and Profit Margins. In the Insert Chart dialog box, go through recommended Charts in the left pane and select the Chart with a Secondary Axis.ģ. Select the Data Set > click on the Insert tab > Recommended Charts option in the ‘Charts’ section.Ģ. The simplest way to Add Secondary Axis to Chart in Excel is to make use of the Recommended Charts feature as available in Excel 2013 and later versions.ġ. Add Secondary Axis Using Recommended Charts Option in Excel So, let us go ahead and take a look at two different methods to add Secondary Axis in a Bar Chart. This deficiency in an Excel Chart can be easily fixed by adding a Secondary Axis to accurately represent the under-represented data (Profit margin in this case). While this Chart does provide fair representation of Monthly Sales figures, it hardly provides any useful information about Monthly Profits earned. In above Chart, the blue bars represent Monthly Sales ($) and the tiny Orange bars represent Profit Margins (%). When this type of mixed data is used to create a Bar Chart in Excel, we end up with a Chart that does not represent the complete information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |