Favorite 2 Axis Excel Chart
Select Design Change Chart Type.
2 axis excel chart. Click in the Chart Data Range and whilst holding CTRL highlight the data that you want to include in the chart. Set your spreadsheet up so that Row 1 is your X axis and Rows 2 and 3 are your two Y axes. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart.
Create the chart with that data range. Right click the chart and choose Select Data from the pop-up menu or click Select Data on the ribbon. Right-click on this chart object and choose Select Data.
Sometimes you want to show several axes in one chart to demonstrate each data series with different formatting and with different axis in one chart. In the Charts group click on the Insert Columns or Bar chart option. You will learn how to add a secondary axis on an Excel c.
Now the new created column chart has a two-level X axis and in the X axis date labels are grouped by fruits. 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 Secondary Axis for the data series you want to show.
Right click on the box that comes up and click on Select Data. If I delete this chart then select both region and code along with activity. Select the source data and then click the Insert Column Chart or Column Column on the Insert tab.
Gather your data into a spreadsheet in Excel. To create one chart for this data follow these steps. Below are the steps to add a secondary axis to the chart manually.