Cool Excel 2 Axis
See below screen shot.
Excel 2 axis. Set your spreadsheet up so that Row 1 is your X axis and Rows 2 and 3 are your two Y axes. Suppose we are making a chart with the data in the Table below and we want to combine the number of Met in column B and of Met in column C togetherStep 2. 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.
Right-click two-finger tap on the series 3. In the Change Chart Type dialog box in the Combo group of charts choose the secondary axis for second data series. To do this right-click on one of the data points for Series 2 and select Format Data Series from the popup menu.
Select Design Change Chart Type. A horizontal axis or x-axis and a vertical axis or y-axis. With the Profit margin bars selected right-click and click on Format Data Series In the right-pane that opens select the Secondary Axis option.
For example A1 needs to equal where row 12 intersects column F on a. When the Format Data Series window appears select the Secondary Axis radio button. Click Insert Column 2-D Column Chart.
Select the series you want to add a secondary axis for 2. Select the source data and then click the Insert Column Chart or Column Column on the Insert tab. Excel 2016 makes the combo chart much easier.
Delete character to the. In this dialog box you can change the chart type for each data series. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group.