How to show Y axis on both sides?
In order to display Y axis values on both sides of the plot area you need to add an additional data series and plot it on the secondary axis. Create a standard column chart based on the data in A1:B6 A B 1 Expenditure 2 Jan 56.3 3 Feb 22.3 4 Mar 46.4 5 Apr 92.7 6 May 15.5 Add an duplicate set of data to the chart.
How to make Excel charts primary and secondary axis the same scale?
You will do the same for the other new series (Secondary Scale). The end result is a chart that will (automatically) rescale the primary and secondary axis to always be the same. This will make the chart much easier to read and interpret. Want to learn more about Microsoft Excel?
How to add a second axis to a chart?
How to Add a Second Axis to a Chart in Excel 1 Select the dataset. 2 Click the Insert tab. 3 In the Charts group, click the Recommended Charts option. This will open the Insert Chart dialog box. 4 Scan the charts in the left pane and select the one that has a secondary axis. 5 Click OK. See More….
Why is the secondary axis not the same as the primary axis?
This makes the chart hard to read. It is almost as if you need another line (red thick line below) to show where the secondary axis crosses at 0. The manual way to fix this is to go into the Axis and manually change the minimum and maximum values. The problem is you need to go into the chart every time the data changes.
How do you make a secondary axis in Excel?
Right-click on the Profit margin bar and select ‘Change Series Chart Type’. That’s it! This will give you a chart that has the secondary axis and the chart type of data on a secondary axis is a line chart. You can also format the line by right-clicking and selecting the Format Data Series option.
How to duplicate the Y axis in Excel?
One of the selections on the left should be Series Options, and one of the options in that group should be ‘Plot Series On’…and Primary Axis should be selected. Choose Secondary Axis. It should duplicate the ‘Y’ axis on the opposite side from where you have it set.