Exemplary Double Axis Graph
At the top of you toolbar select Insert Line and click on the first line graph.
Double axis graph. Select a chart to open Chart Tools. In the right-pane that opens select the Secondary Axis option. By adding a secondary axis to the chart appearing on the right of the chart we now have two vertical axes.
Create a chart with your data. When a Combination Chart Type is used the Dual Y property is Split Dual OnOff. Note that this kind of chart has major drawbacks.
However should there be different units of measure in your data a secondary axis will be required thus allowing you to create a dual chart in your Microsoft Excel workbook. Setting up a chart with a secondary Y-axis requires changes to two places. To create one chart for this data follow these steps.
Select Combo Cluster Column - Line on Secondary Axis. For example if you have two too different data eg volume and price which you want to see in one chart. In the Chart Data view select the data rows and columns to include in the secondary Y-Axis.
They illustrate a lot of information with limited space and allow you to discover trends you may have otherwise missed if youre switching between graphs. Following are the. The axis on the left is scaled for sales whereas the axis on the right is scaled for quantity.
Select Secondary Axis for the data series you want to show. It uses the secaxis attribute to add the second Y axis. Go to tab Series Options.