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.

Use the "Insert" tab on the command ribbon to convert these two data series on a scatter chart. This scatter chart can also illustrate a Word document and a PowerPoint presentation.

Learn about the various types of graphs, charts and diagrams useful when presenting sets of data, with BBC Bitesize 3rd Level Maths.