The DataHero Blog
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. Following 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.
For example, if you have two too different data e. For example, on the Insert tab, in the Charts group, choose the Column button:. Choose the Clustered Column chart. In the Change Chart Type dialog box, in the Combo group of charts, tow the secondary axis for second data series:.
How to add next data series with another axis, see Combining several charts into one wgat. See also this tip in French: Comment utiliser deux axes dans un graphique. If you have any questions or suggestions, please feel free to ask OfficeToolTips team.
If you encountered a bug or want to suggest a feature in Microsoft Office, grapb recommend you contact Microsoft Support. We are not a division, a subsidiary, or a contractor of Microsoft Corporation, and we are not responsible for their decisions. Also, we are not responsible for access configuration or software updates in your company.
Contact your company support team and install latest updates before asking questions. Using two axes in the one chart. Excel 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. Ask Kn. Failed to send the question.
Please try again. See Also. Simple combination chart Sometimes you want to show a single chart that consists of series that use different grapb types. Combining several charts into one chart If you want to combine more than two different data series with common horizontal and different vertical values, you could not just add another axis to the chart. You need to combine several charts into one chart.
Using Pie Charts and Doughnut Charts in Excel If you have several parts of something one, you can demonstrate each item in one pie chart. But sometimes you want what causes radon in basements demonstrate the changes in those parts, and a doughnut chart will help you to arw this.
Browse all dual axis chart templates
Using two axes in the one chart. Excel 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. For example, if you have two too different data (e.g., volume and price), which you want to see in one chart. Apr 23, · A dual axis chart is a great way to easily illustrate the relationship between two different variables. They illustrate a lot of information with limited space and allow you to discover trends you may have otherwise missed if you’re switching between graphs. . A dual axis chart (also called a multiple axes chart) uses two axes to easily illustrate the relationships between two variables with different magnitudes and scales of measurement. The relationship between two variables is referred to as correlation. A dual axis chart illustrates plenty of information using limited space, so you can discover trends you may have otherwise missed.
This article is brought to you by Datawrapper , a data visualization tool with which you can create charts , maps and tables. Learn more. Tl;dr: We believe that charts with two different y-axes make it hard for most people to intuitively make right statements about two data series. We recommend two alternatives strongly: using two charts instead of one and using indexed charts.
Why do people use dual axis charts? We looked around and found that most people used them to show…. Often, their goal is to compare two trends with each other. Giving readers the possibility to do so makes a lot of sense — but there are some reasons why a dual axis chart is not the way to go. In fact, of these four use cases, we think that only the last dual axis chart can be used without any doubt, since it only uses the second Y-axis to show an alternative scale and not a second data series.
The measure US-Dollar is the same, but we have a wildly different magnitude. A second axis sounds like a good solution — but there are three problems we have with them:. The proportions of the two scales are often different from each other in dual axis charts. If the left axis would go down to zero, the chart would be twice as long. If the right axis would go down to zero, the chart would be almost three times as long.
This is how both axes look like when we extend them to zero:. Most readers are used to line charts with just one scale. So how small is the relationship between these two lines? Nothing really matters, right? We can make all kinds of statements with our two data sets if we just tweak the scales a little bit:. We can just set the zero baseline to the same height. This is how the chart looks like with the same baseline. Meaning, if we extended both y-axes to zero, they would have the same height.
Why would anyone think that? Data points and data series are not an exception to this rule. I stared at this chart for a minute and I figured everything out. Which is ok: Our job is to do the math for them. A study from backs up that claim.
Petra Isenberg, Anastasia Bezerianos, Pierre Dragicevic and Jean-Daniel Fekete showed 15 people four different charts that all showed values in different magnitudes, and observed how well these people could read the charts.
We found across the board that the superimposed chart performed poorly both in terms of accuracy and time. Participants called it very confusing and demanding too much concentration or reflection to decipher the non-monotonic and discontinuous nature of the two scales. The researchers go on and recommend to avoid dual axis charts altogether. We agree. Chart designers have the freedom to manipulate axes as they wish, which can lead to first visual impressions which are way off what the data actually says.
There are alternatives. Here we will present four of them: Creating two charts, indexed charts, labeling and connected scatterplots. The first solution is to create two different charts with our two data series, also called side-by-side-charts. The disadvantage is that two charts might need more space than one chart.
If we want to keep both data series in one chart, we can create an indexed chart. Labeling or tooltips can bring back information about the absolute numbers. And one can even show more than two data series in the same chart, as happened in this chart by my co-worker Gregor, who compares the growth and decline of several cryptocurrencies with each other.
This approach works only for data series with a similar rate of change, though. The third idea to prevent a dual axis is to just show one line: the more important data series of the two. We can then use chart annotations to add information about the data we leave out the other data series. For example, the following chart shows the unemployment rate in the US, but gives information about the absolute numbers in form of annotations:.
Here it gets fancy: A connected scatterplot keeps one variable on the y-axis — but instead of time, it places the second variable on the x-axis. Stephanie Evergreen recommends it as an alternative to a dual axis chart in one of her articles. Of the four alternatives we show here, the first two will be useful in most cases. Let us know if we missed anything!
We hope we could make our concerns understandable and show some ways how you can visualise your data even without a dual axis chart. Explains two alternatives to a second Y-axis, two side-by-side graphs and a connected scatterplot. Be gone, dual y-axis! Shows a case when indexed charts as an alternative for dual axis charts fail, and suggests a labeled chart instead.
Dual axes time series plots may be ok sometimes after all by Peter Ellis. Note that both the dual axis chart and the connected scatterplots are not intuitive, but differently so: The dual axis chart promises the reader to be easily decipherable , since it looks like the common line-chart that readers have seen so often and learned how to read.
Opinions 10 min. Why not to use two axes, and what to use instead The case against dual axis charts. Lisa Charlotte Rost. She's been writing and talking about data vis for a few years now and is excited to learn and teach. Lisa likes emails, so write her at lisa datawrapper. Liked this article? Maybe your friends will too: Twitter Facebook.
Related Articles. The case for choosing clarity over complexity in data visualizations December 23rd, What we wrote about in the last year October 16th, All Blog Topics. Weekly Charts. How to deal with data. How others use us. Datawrapper News. Data Vis Book Club. Covid Vis.