Show How to Create Dual-Axis Charts in Excel
Dual axis charts, also called combo charts, are great when you have two different kinds of information to present in the same chart. For example, you can have a column chart representing sales data and a line chart representing commission amounts displayed together. Create a Dual Axis Chart
Add Secondary Axis TitlesBy default, the primary and secondary axis values are not labeled in the chart. Adding labels helps clarify the data being presented.
The primary and secondary axis titles are added to the chart.
FREE Quick ReferenceClick to Download Free to distribute with our compliments; we hope you will consider our paid training.
If you have data range as shown as below, and you want to make two y axes in chart for more clearly viewing the data, how could you do? Here I will tell you the detail on making two y axes in a chart in Excel. Make two y axis in chart Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier... Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Make two y axis in chartFollowing the below steps, you will find that making two y axes in chart is very easy. 1. Select the data range, and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. 2. Right click a column in the chart, and select Format Data Series in the context menu. See screenshot: 3. Then in Format Data Series dialog, check Secondary Axis in the Plot Series On section, and click the Close button. See screenshot: 4. Then right click the red column in the chart, select Change Series Chart Type. See screenshot: 5. In Change Chart Type dialog, click Line in left pane, and select the line chart type you like. See screenshot: 6. Click OK to close dialog, and you see the chart is inserted with two y axes.
Note: In Excel 2013, you need to change the chart type by right clicking the column, and select Change Series Chart Type to open the Change Chart Type dialog, then click All Charts tab and specify series chart type and the secondary axis in Choose the chart type and axis for your data series section, then click OK.
Relative Articles:
The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Comments (1) No ratings yet. Be the first to rate! How do you make a bar graph with two y axis in Excel?Add or remove a secondary axis in a chart in Excel. Select a chart to open Chart Tools.. Select Design > Change Chart Type.. Select Combo > Cluster Column - Line on Secondary Axis.. Select Secondary Axis for the data series you want to show.. Select the drop-down arrow and choose Line.. Select OK.. Can you have 2 y axis in Excel?Microsoft Excel gives you the option to add a secondary axis to your graphs. To add a secondary axis, you'll need to edit the Series Options. To change the chart type of the secondary axis, you can right-click the graph and select the option.
Can you have 2 y axis on a graph?A second Y axis is a Y axis drawn on the right-hand side of a chart. It can show the same axis scale as the primary Y axis or a different scale. You can use a second Y axis with the same scale as the primary Y axis on a wide chart to help viewers interpret the data more easily.
|