Can there be 2 y axis?
When the data values in a chart vary widely from data series to data series, or when you have mixed types of data (for example, currency and percentages), you can plot one or more data series on a secondary vertical (Y) axis.
How do you split the y axis in Excel?
In the opening Change Chart Type dialog box, go to the Choose the chart type and axis for your data series section, click the For Broken Y axis box, and select the Scatter with Straight Line from the drop down list, and click the OK button.
How do you add a second Y axis to a graph?
To add other lines to the Y-axis, click the checkbox below “Y-axis” to the right of the data series in the lower-right corner of the window. Select the type of chart for each data series. In addition to graphing a data series on a separate Y-axis, you can also graph it on a different chart type.
How do you make a double line graph on Excel?
How to create this double axis graph.
- At the top of you toolbar select Insert, Line and click on the first line graph.
- Right click on the box that comes up and click on Select Data.
- Click in the Chart Data Range and whilst holding CTRL highlight the data that you want to include in the chart.
How do you plot two variables on the y axis?
The way to make a plot with two different y-axis is to use two different axes objects with the help of twinx() function. We first create figure and axis objects and make a first plot. In this example, we plot year vs lifeExp. And we also set the x and y-axis labels by updating the axis object.
How do you make a line break in Excel?
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).
How do you create a line graph in Excel with two sets of data?
Below are steps you can use to help add two sets of data to a graph in Excel:
- Enter data in the Excel spreadsheet you want on the graph.
- Select the data you want on the graph.
- Click the “Insert” tab and then look at the “Recommended Charts” in the charts group.
- Choose “All Charts” and click “Combo” as the chart type.