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.
Chart elements category
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 […]
Excel categories
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.