The following examples show reference lines that examine the trend on a scatterplot and the shape of the data on a histogram.
This time series plot displays actual sales data (the line that connects the symbols) with a calculated line that represents target sales (the straight line). This graph shows that usually actual sales surpassed target sales. However, you might want to examine the instances where sales did not meet the target to determine the cause.
This graph shows that the actual engine failure times (the histogram) aren't a very good fit with the theoretical distribution (the solid line).
For example, you create a scatterplot and you want to add a line drawn with specific coordinates. The calculated line coordinates are (1,2) and (5,6).
C1 | C2 | C3 | C4 |
---|---|---|---|
Weight | Height | X | Y |
3.97 | 3.46 | 1 | 2 |
2.5 | 1.01 | 5 | 6 |
4.2 | 3.73 | ||
2.19 | 2.02 | ||
... | ... |
Follow these steps to enter coordinates for a calculated line and then add the calculated line to a graph.
Calculated lines do not update when you change the coordinates. You must add a new calculated line with the updated coordinates.
You can edit the color, size, line type, arrow style, and coordinate system for a calculated line.