![how to format x axis in excel 2013 how to format x axis in excel 2013](https://www.spreadsheetweb.com/wp-content/uploads/2019/04/combination-chart-8.png)
Press the Delete Key on the keyboard of your computerĪlternately, you can also right-click on the secondary axis and click on the Delete option in the contextual menu. Select the Secondary Axis by clicking on it.Ģ.
#HOW TO FORMAT X AXIS IN EXCEL 2013 HOW TO#
How to Remove Secondary Axis from an Excel Chart?Īll that is required to remove secondary axis in an Excel Bar Chart is to select the secondary axis and press the Delete key.ġ. You will now have a Bar Chart with a Primary Axis representing Sales Data ($) and a Secondary Axis representing Profit Margins (%). In Change Chart Type dialog box, change the Profit Margin Chart type to Line with Markers.
#HOW TO FORMAT X AXIS IN EXCEL 2013 SERIES#
Now, right-click on the Profit margin bar and select Change Series Chart Type option.Ħ. This will add a secondary axis to the existing bar chart and you will end up with two overlapping bars.ĥ. In the right-pane that appears, select the Secondary Axis option. After selecting the Minor Bars, right-click and select Format Data Series option.Ĥ. If the minor bars are tiny, select the Major or Larger bars ( Sales Bars) and hit the Tab key.ģ. In the inserted Chart, select the Minor bars ( Profit bars). Select the Data Set > click on the Insert tab and select 2-D Clustered Column Chart option.Ģ. If you do not find a Chart with secondary axis, you can manually add a secondary axis by following the steps below.ġ.
![how to format x axis in excel 2013 how to format x axis in excel 2013](https://i.stack.imgur.com/3wGi8.png)
Manually Add Secondary Axis to Chart in Excel When working with non-scatter plots, Excel's default labels are just the integers from 1 up to the number of data points you have. 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. The 'Format Axis' dialogue box also allows you to change the interval and appearance of tick marks, the font of your labels and other aspects of the appearance of your chart. 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.