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-click 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-click on left y-axis values to open the settings pane.
- Go to tabĀ "Fill & Line"
- Expand Line settings.
- Click "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-click the right y-axis to open the settings pane.
- Expand "Axis Options".
- Change Maximum to 0.2
- Close the settings pane.
How to customize the plot area
The plot area refers to the location of the chart that displays the actual data represented by lines, bars, columns, […]
How to customize chart axis titles
The x-axis and y-axis titles are just as easy to format and customize as the other chart elements. How to […]
How to customize a chart data series
To change the looks of a data series simply double-click with left mouse button on the data series. If you […]
Most Excel charts consist of an x-axis and a y-axis, Excel allows you to easily change the looks of […]
How to customize chart tick marks
The image above shows tick mars in a line chart, there are two types of tick marks, major and minor […]
How to add and customize chart data labels
The image above demonstrates data labels in a line chart, each data point in the chart series has a visible […]
How to add a linear trendline to a chart
Excel allows you to insert a linear chart trendline that displays a straight line calculated based on the method of […]
How to add a moving average to a chart
A moving average smooths out short-term variations to show a long-term trend or cycle. The chart above shows random values […]
How to customize the chart legend
You can easily customize the font, font size, font color etc of the chart legend: Select legend. Go to tab […]
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.