Great Dual Axis Line Chart
Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group.
Dual axis line chart. Dual Y axis line chart The doubleYScale function of the latticeExtra package can take 2 outputs of the xyplot function to build a dual Y axis line chart. In the March 2020 update the Y2 axis was added for the line chart which is great. Always double check what axis trully are on dual axis chart.
These graphs are called double axis or secondary axis. You can also plot the secondary Y-axis as a split dual chart where the secondary Y-axis appears with its data series below the original chart. 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.
A dual axis line chart is needed when you have 2 sets of data to display with significantly different scales like the one shown below. This chart is truly misleading. 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.
Right-click on the Profit margin bar and select Change Series Chart Type. It uses the secaxis attribute to add the second Y. In the Chart General Properties set Toggle Dual Y Split to one of the following.
The line chart leads me to think that time is on the x-axis or there is a relationship between the series which is not accurate. Excel 2016 365 2013 2010 2007 2003. Chart showing a combination of a column and a line chart using multiple y-axes.
They can include bar charts line and scatter graphs and many more. Also nice use of color. A dual axis chart combines a column and line chart and compares two variables.