Capture relationships between data sets by graphing linear equations in Microsoft Excel 2007. Linear equations allow you to predict values within your data set and view the overall trend.

Linear equations can be shown on a graph. Find out how to create one in this Bitesize KS3 maths video.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.