how to plot a graph in excel with 2 axes

How to plot three variables on a line graph.

This tutorial will guide you on how to plot three variables on the same graph, so follow the steps below: To create any of the above line graphs with three variables, follow these simple steps 100% Stacked Line Graph with Markers which is similar to a 100% stacked line graph, though it indicated data points.Stacked Line Graph with Markers which is similar to a stacked line graph, although it marks data points.Line Graph with Markers shows the change over time but marks the data points.This graph makes a straight line at the top. 100% Stacked Line Graph which shows the proportional contribution to the trends and scales the line so that the total change in variable becomes 100%.Instead, there are cumulative points for each row.

In a stacked line graph, the points will not intersect.

Stacked Line Graph which shows a gradual change in the whole data set over time.

Line Graph which shows trends over time for larger components or data sets.

The representation can be positive or negative values shown when the line passes through a horizontal axis. In simple terms, a line graph represents quantitative data set visually.

A line graph consists of two axes a horizontal axis or X-axis that shows independent or fixed data and a vertical axis or Y-axis that represents variable data. It also easily represents a change in multiple variables compared to specific variables. But what will you do if you have three sets of data to plot on the same graph? This might sound strange, but excel is a hub of multiple possibilities.Ī line graph connects different data points, making the trends easy to understand. You can use the XY graphs to plot and compare two variables, the trend and how they vary against each other. Data analysis involves plotting graphs, and the XY graphs are among the most potent ones.

How to plot a graph in excel with 2 axes