Two y-axes in one chart
The image above demonstrates a line chart containing two data series and two y-axes, one for each data series. I changed the color of the y-axes so they match the corresponding color of the data series.
A secondary y-axis is very useful if the data points of the second data series are way off. You won't be able to read the chart if they share the same y-axis, here is an example:
This chart shows two data series, however, only one is readable. Here is how to add a secondary axis:
- Double-press with left mouse button on one of the two data series in the chart to open the task pane.
- Go to tab "Series Options".
- Select "Secondary Axis".
Add y-axes lines
Double-press with left mouse button on left y-axis values to open the settings pane.- Go to tab "Fill & Line"
- Expand Line settings.
- Press with left mouse button on "Solid Line"
- Pick a color.
- Repeat steps 1 to 5 with the right y-axis.
Add major tick marks
- Go to tab "Axis options".
- Expand "Tick Marks" settings.
- Pick a major type tick mark.
- Repeat step 1 to 3 with the right y-axis.
Change the right y-axis boundary
The data series collide and to make it better looking we can adjust the upper and lower y-axis range.
Double-press with left mouse button on the right y-axis to open the settings pane.- Expand "Axis Options".
- Change Maximum to 0.2
- Close the settings pane.
Related articles
If you try to copy multiple cell ranges on a worksheet that don't have the same number of rows or […]
Charts in Microsoft Excel lets you visualize, analyze and explain data. Charting in Excel is very easy and you […]
Excel allows you to insert a linear chart trendline that displays a straight line calculated based on the method of […]
Excel lets you easily add a best-fit curved logarithmic trendline calculated based on the method of least squares. How to […]
A moving average smooths out short-term variations to show a long-term trend or cycle. The chart above shows random values […]
The image above demonstrates data labels in a line chart, each data point in the chart series has a visible […]
Chart gridlines are great for making the chart data more readable and detailed, Excel allows you to add major and […]
Enable error bars when you want to show, for example, standard deviations in a chart, Excel lets you insert error […]
To change the looks of a data series simply double-press with left mouse button on with left mouse button on […]
Most Excel charts consist of an x-axis and a y-axis, Excel allows you to easily change the looks of […]
The x-axis and y-axis titles are just as easy to format and customize as the other chart elements. How to […]
The image above shows tick mars in a line chart, there are two types of tick marks, major and minor […]
The chart area contains all components. If you choose to format the chart area you can change things like border, […]
You can easily customize the font, font size, font color etc of the chart legend: Select legend. Go to tab […]
I recommend that the chart title is short and easy to understand. How to add a chart title Follow these […]
The plot area refers to the location of the chart that displays the actual data represented by lines, bars, columns, […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
