For example, you could show line graphs for temperature and humidity on top of each other. For this purpose, Excel lets you add a series of data to a chart and plot it on a second y-axis.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.

The two graphs, like a dot plot, have both an x- and y-axis. You can calculate the spread of the dots by subtracting the minimum value from the maximum value on the chart.

Learn how to plot coordinates and create straight line graphs to show the relationship between two variables. Also, plot graphs that contain a negative coefficient of x.

I am getting rather pissed off at Excel. I keep trying to make a Bode plot with the X-axis being 5 Cycle semi-log (just a log10 axis would be alright too) and the Y-axis linear. I cannot find an ...

Revise how to plot a linear equation graph. Learn how to read x and y coordinates from a graph in this BBC Bitesize maths KS3 guide.