Marvelous Double Axis Graph Excel
Click on one of the bar charts.
Double axis graph excel. This frequently happens in PPC. On the right side you will find the data Series Names 2 drop-down menus under the Chart Type heading and 2 checkboxes under the Secondary Axis title. Select the data set Click the Insert tab.
Following the below steps you will find that making two y axes in chart is very easy. First select the Insert tab from the toolbar at the top of the screen. Click Insert Column 2-D Column Chart.
A blank chart object should appear in your spreadsheet. On a Windows PC Using Excel 2013 1. How to create this double axis graph.
Select Combo Cluster Column - Line on Secondary Axis. Select the first column product column except for header row. This approach works with chart types that have an Category type category X axis that is.
The chart below shows defect rates in several different components which are grouped into a smaller number of categories. Set your spreadsheet up so that Row 1 is your X axis and Rows 2 and 3 are your two Y axes. 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.
At the top of you toolbar select Insert Line and click on the first line graph. Select Design Change Chart Type. Right click on the box that comes up and click on Select Data.