how to plot a graph in excel with two y axis

In this case, the graph would tell more if the percentages showed on the Secondary Axis, which is shown on the right side. Since Revenue is in $ and Net Income is in %, the Net Income barely shows on the graph. In this case, we added two series: Revenue and Net Income. Therefore, you can visually show two separate series in one graph by using this. The Primary Axis shows the range of Total Revenue, and the Secondary Axis shows the % of Net Income.

You can see that these include different ranges on both axes. In the below graph, you can see an example where there is both a primary axis and a secondary axis. This can be helpful when you’re plotting value ranges in a number of series that vary greatly, or when you’re trying to graph two separate kinds of charts (commonly bar and line graph). Notice that the products are displayed along the x-axis instead of the. In the Charts group, click the first chart option in the section titled Insert Line or Area Chart. Click the Insert Tab along the top ribbon. There are a variety of ways that a secondary axis can come in handy. We can use the following steps to plot each of the product sales as a line on the same graph: Highlight the cells in the range A1:C5. How to Add Secondary Axis (X & Y) in Excel

This tutorial will demonstrate how to add a Secondary Axis in Excel and Google Sheets. A line graph has a horizontal and a vertical axis and uses one or more lines to show where two values intersect. Return to Charts Home How to Add Secondary Axis (X & Y) in Excel & Google Sheets Create, Save, & Use Excel Chart Templates

How to plot a graph in excel with two y axis