SHARE THE ARTICLE ON
A dual axis chart also known as multiple axes chart, employs two axes to clearly depict the connections between two variables of varying magnitudes and scales of measurement. Correlation is the term used to describe the relationship between two variables.
A dual axis chart conveys a lot of information in a little amount of area.
When the data values in a chart differ significantly from one series to the next, or when you have mixed forms of data (for example, currencies and percentages), one or more data series can be shown on a secondary vertical (Y) axis. The supplementary Y-axis scale represents the values for the related data series.
While the secondary Y-axis can be used with any line or bar chart type, it is most typically employed with combination charts to assist differentiate the data series shown on the secondary Y-axis.
Dual axis charts are used to compare two trends to one another. These might be two separate data series with the same units but different magnitudes, or two other data series entirely.
Conducting exploratory research seems tricky but an effective guide can help.
It is entirely dependent on the requirements.
Dual axis charts are frequently used to display two distinct data series with varying magnitude (=number range) and/or measure (GDP, life expectancy, etc.). Frequently, their purpose is to compare two trends.
We must exercise extreme caution while synchronizing the axis. This can be beneficial to us at times, but it can also be detrimental to the user’s experience. For instance, we have the following requirements:
These criteria might, as we suspected, come from an affiliate network. The affiliate network may like to show their publisher how much they make on a daily basis as well as how many clicks, they receive on a daily basis. In this situation, it is rather evident that the number of clicks will much outnumber the quantity of earnings.
There may be a day when the number of clicks is 100 and the income is USD 1, and this tendency may continue.
If we synchronize our earning axis in this scenario, it will be approximately about the x-axis. And this may not be the best reporting habit. So, if we have one axis with a very large range and another with a smaller range, we should avoid synchronizing the axes.
When we have two majors with comparable units, such as profit and discount. We should think about synchronizing our axes in this scenario. Again, there is no hard and fast rule on when to synchronize and when not to. This is entirely dependent on your needs.
Consider altering the name of the other axis after we’ve synced it. This will assist the user in avoiding becoming confused by the name. In our scenario, after we’ve synced both the profit and sales axes, we may conceal one of them.
Assume we’re concealing the profit axis. The other axis will then say sales, which is not quite correct because that accepts will reflect both sales and profit. In this scenario, you may need to rename the axis. To rename an axis, just right-click on it and change the name.
Display Variables with Extremely Distinct Scales
It is much simpler to observe two variables with significantly different scales inside the same graph than it is to switch between two charts. It also takes up less room in PowerPoint presentations.
Display Variables in Various Numerical Units
A dual axis chart can also display two numerical values with distinct units, similar to the preceding approach. In the graphic below, for example, there is a link between the number of homes for sale and the average home price in California. This compares the value of a currency to the value of a rounded number.
Don’t Overburden Your Charts
A chart can only carry so much information before becoming unwieldy. Keep your chart to one point by demonstrating the relationship between two variables. There are four lines in addition to the columns in the example below.
Switching back and forth between examining the legend and the chart becomes quite visually confusing. Because the axes are so dissimilar, the bottom line can only be seen through the triangles.
Don’t Forget to Track Best Practices
This one may appear apparent, yet it is easy to overlook. Simply because we have two axes does not mean that other charting recommended practices do not apply. A line chart, for example, is not the ideal approach to display categorical data. They’re best kept for long-term patterns.
Lines indicate a trend over time. As a result, the line in the figure above is perplexing since it represents a trend with categorical data.
In dual axis charts, the proportions of the two scales are frequently varied. The chart would be twice as lengthy if the left axis was set to zero. The chart would be nearly three times as lengthy if the right axis was set to zero. When we extend both axes to zero, they appear like this:
The chart looks like this with the same baseline. In the best-case scenario, our readers will now think, “It appears that global GDP rose more than German GDP.” It appears that the German GDP was greater than the world GDP in the early years. Then, in 2011, the two GDPs were equal:
When items appear near on a chart, it might be difficult to recall that they are actually thousands of kilometers distant.
2011 research backs up that assertion. Petra Isenberg, Anastasia Bilzerian, Pierre Dragicevic, and Jean-Daniel Fekete showed 15 participants four distinct charts with values of varying magnitudes and assessed how well they could understand the charts. One of these was a chart with a dual axis, dubbed a “superimposed chart” by the researchers. That’s what they discovered:
We found across the board that the superimposed chart performed poorly both in terms of accuracy and time. Participants’ feedback from the questionnaire was also clearly against the superimposed chart and it was ranked lowest by all but one participant. Participants called it very confusing and demanding too much concentration or reflection to decipher the non-monotonic and discontinuous nature of the two scales.