In this case, the date column (column A) was omitted from the chart source data as it was irrelevant to the relationship between the two variables. This defeats the purpose of a chart, which is to simplify complex data.Ī scatter plot of the same data, on the other hand, would look like this:Ī clear inverse relationship is shown between both variables on the above scatter plot. If you’re trying to establish correlation between the two variables, it is difficult to determine a pattern.We cannot clearly see the disparity between the temperature on March 14 (2.5 degrees Celsius) and the one on March 20 (16.2 degrees Celsius). Since the numbers being used to measure each variable are so far apart, it is difficult to see the changes and fluctuations to the numbers which carry a smaller value (Daily Temp).Two limitations of the above line chart are: The following shows the result of creating a line chart when a scatter graph should have been plotted instead. Let us suppose that we had the following worksheet data:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |