Smart Dual Axis Line Graph

To create one chart for this data follow these steps.

Dual axis line graph. Double-clicking it displays the Format Data Point menu to. We will change that by setting axistext theme items with element_text. An axis is a very important component of any graph and it represents the quantitative measure based on which visualization is created.

Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. While creating a dual y-axis line chart is pretty common in excel it is not as easy in power BI. How to create this double axis graph.

Right click on the box that comes up and click on Select Data. Using two axes in the one chart. Excel 2016 365 2013 2010 2007 2003.

I did search again and found this topic How to add second Y-axis for Bar and Line chart in Chartjs. Update 11 Mar 2020. For example if you have two too different data eg volume and price which you want to see in one chart.

The only standard chart that comes with Power BI Desktop that enables dual y-axis is the Column and line combo chart types. Quickly glancing at a dual axis chart for a second can plant misleading statements in a readers mind. Dual Y axis with R and ggplot2 This post describes how to build a dual Y axis chart using R and ggplot2.

A secondary y-axis is very useful if the data points of the second data series are way off. In the March 2020 update the Y2 axis was added for the line chart which is great. Chart showing a combination of a column and a line chart using multiple y-axes.