how to plot a graph in excel with two y axis

As we can see, the line in the chart is growing as our data in the columns. You can choose any chart among those options within your preference.Īfter selecting the preferred chart option, excel will plot a chart using the data from those columns. Our data set has two types of categories and if we want to plot them, we need a chart type that shows the data points with smooth lines and markers which can make the chart visually easier and more readable. I am going to choose “Scatter with Smooth Lines and Markers”.

Scatter with Straight Lines and Markers.

Now, there are five types of options in the scatter chart. There is a section named “Charts” and you will find an option named “Scatter” among other chart options. Now, after selecting the data, go to the “Insert” ribbon. We are going to select from cell A2 to cell B13 because we have our data in those cells. So, we have our data in the A column (X- Values) and B column (Y- Values). In the second step, select the data and plot x vs y in excel. Now our next task is to insert a scatter chart using those data. I am going to put the x-values into the A column and the y-values into the B column. We are going to insert that data into two columns in an excel sheet. In this case, we have x-values and y-values. The first step, we need two types or categories of data set. In this section, we are going to learn how to plot x vs y in excel in 4 easy steps. How to Plot X Vs Y in Excel? (Step by Step) In this article, we are going to learn how to plot x vs y in excel using a scatter chart. We can plot x vs y in excel with three steps. We want to plot x vs y in excel, which means that we want to plot a scatter chart. A Scatter chart is an easier option to compare and visualize data in excel and it has so many real-life examples. When you have two categories of data, for example, x and y, and you want to compare those data, plotting a scatter a chart is an effective option. With a range of data, you can plot a chart in excel within a few clicks. You can manipulate, analyze, and display your data in many ways using a range of graph options in excel. Excel gives us a variety of options to visualize data.

How to plot a graph in excel with two y axis