how to plot a graph in excel with two variables

X-Y plots are used to determine relationships between the two different things.

Area graphs are good to use when you are tracking the changes in two or more related groups that make up one whole category (for example public and private groups). They can be used to track changes over time for one or more groups. However, when trying to measure change over time, bar graphs are best when the changes are larger.Īrea graphs are very similar to line graphs. They do not show changes over time.īar graphs are used to compare things between different groups or to track changes over time.

Pie charts are best to use when you are trying to compare parts of a whole. Line graphs can also be used to compare changes over the same period of time for more than one group. When smaller changes exist, line graphs are better to use than bar graphs. Line graphs are used to track changes over short and long periods of time. What are Independent and Dependant Variables? How to Choose Which Type of Graph to Use?

How to plot a graph in excel with two variables