Question

Difference between line chart and scatter chart

Answer 1

Line chart

The values ​​are plotted only on the vertical axis (Y-axis). On the horizontal axis (X-axis) is the sequence number of the value. Exceptions are graphs with the date on the X-axis.
The line chart for this table contains two lines because there are two data series (Value1 and Value2). The line of Value 1 (blue) is down because Value1 and Value2 ​​are in very different scale. On the X-axis you can see numbers 1 to 9, that’s because we have 9 rows in the source table.
The line chart of the Value 1 is on the following picture. You can see that the values are on the vertical axis (Y-axis) and on the horizontal axis (X-axis) are still only the sequence numbers.
The line chart for Value 2:
As you can see in the previous examples, the line chart shows each data series (values in columns) separately into the color lines.

Scatter chart

When you want to show the relationship between two values, use the scatter chart. Scatter is often called XY chart.
On the following picture is the scatter chart for Value 1 and Value 2. On the vertical axis (Y-axis) are Values 1 and on the horizontal axis (X-axis) are Values 2. In this chart are only 6 points, it’s because 4 of the rows have the same XY coordinate (Value1=22, Value2=250000).
Line and scatter chart with the date
The line and the scatter chart of this table are nearly the same.

Answer 2

scatter plots show how much one variable is affected by another. line graph are like scatter plots in that they record individual data values marked on the graph is difference is that a line is created connecting each data points together in this way the local change from point to point can be seen