Nice Add Second Y Axis To Excel Chart
Steps for Adding a Secondary Axis in Your Chart Here are the simple steps you need to follow to create a dual axis.
Add second y axis to excel chart. Select a chart to open Chart Tools. If you are using Excel 2010 you can add a right handside Y axis in a chart as follows. By duplicating the data.
Then choose the Combo option from the left menu. Get the Free Excel Shortcuts PDF. For the purposes of this process well create three rows of data.
Create a chart with your data. Following are the steps you should follow to add a secondary axis to your Excel chart. First select one of the data series and select secondary next in select secondary x axis.
Add your second data series. Right Click on it and go to Format Data Series Series Option Activate Secondary Axis. Click on it and it is done.
Add your second data series. Create a chart with your data. Add your second data series.
When you add the secondary horizontal axis Excel adds it to the top of the plot area shown as blue in the above example. Make two y axis in chart Following the below steps you will find that making two y axes in chart is very easy. Gather your data into a spreadsheet in Excel.