When I select Temp 2, the corresponding graph formula is: They are both plotted in the graph.Īs shown in the plot, the blue Temp 1 has been "selected" in the graph and the corresponding graph formula is:
Temp 2 starts at 9:30:00 AM and increments by 2 minutes and 53 seconds. Temp 1 starts at 9:00:00 AM and increments by 1 minute and 26 seconds. Below is a screenshot of an Excel sheet where two temperatures are shown. In order to make it look more professional, set the maximum on the y-axis to 50, this will plot line across the height of the graph – select Y-Axis > Format Axis > Axis Options: Minimum set to Fixed & Zero and Maximum also set to Fixed & 50.Use a Scatter Plot where the horizontal axis is time. Remove Markers (Select Series > Format Data Series > Marker Options > None), repeat this for Last_Line as well. Make color similar – both be the Myron Lines. Now these two lines can be formatted to suite our taste: In the same way we can add the end line to the chart – let’s assume the data to be the End_Line, we reach the following stage: Select the chart then right click – select Data select Add will lead you this dialogue box Let’s assume we are adding series named “Start Line” Before we add the series to the chart we need to add the two tables to the sheet as well, that will list the points to be plotted (see right side figure) Hence for the starting point we need to plot the following line – (1,0)-(1,50) how will we do that? Will do that by simply adding another series of data to the chart. How we can see that the starting point has coordinates (1,33) and the end point has coordinates (15,4) – if we choose to draw at these points, the abscissa of both the lines should be 1 and 15 and the length along y-axis could vary as per our requirement (say from 0 to 50) We first plotted the data, using a line chart (Insert > Line Chart > Line Chart with Markers) – that results in the following graph: Same was true for the line at the end of the series – the value along the x-axis does not change for the line but it does for the y-axis – resulting in a vertical line. This will make sure that the line starts from the start of the series. The first important point was to note that the for the start and the end line, we need to have the same x-value for the coordinates as has the first point of the series. Let’s see how we can do this in Excel! – What we needed to do is to put a separate line at the start and the end of the actual data. So we took up the task and worked out the solution. The question dragged our attention as it is not usual to mark the start and the end of the lines with markers – but to draw and entire line is a different thing.
One of the Quora users recently asked a question regarding how to plot lines at the start and the end of a data series.
0 kommentar(er)
