You record the data in a scatter chart, setting "height" to the x-axis, and "weight" to the y-axis. For instance, to display a link between a woman's height and her weight, you need to choose a group of women to research, then measure their height and weight. Scatter charts feature displaying values for typically two values for a set of data, thus illustrating the degree of correlation between two variables. Looking at the line graph below, you may feel puzzled because it's painstaking to draw lines of data from many women from the charts one by one and then draw a conclusion. However, two women's data is far from enough. However, it's almost impossible to put two variables in one line chart.įor example, if you want to explore the correlation between women's weight and height using line charts, you need to draw at least two lines - regering to two women's height and weight information. On the y-axis, numerical values are recorded with points obviously. On the x-axis, category data are distributed with even intervals. In the line chart, you can record the continuous periodic data conveniently. Here I present the correlation between weight and height using line graph and scatter chart respectively. Look at the pictures below, you may find that the line graphand the scatter chart look similar. This article offers a guide on how to choose between line graphs and scatter charts. How and when to use line graph has always confused many people. Next, in the Format Error Bars pane, under Error Bar Options, set the Error Amount to Fixed Value of 0.07.As prevalent data presenting tools, line graphs and scatter charts have similar appearance but totally different using occasions and data distribution on horizontal and vertical axes. Then, in the chart right-click the Series “Label” Y Error Bars and then, on the shortcut menu, click Format Error Bars. Next, change the y coordinate of the bars to 0.09 (range D4:D203) to align the bars with the horizontal axis.Ĩ.
Under Marker Options, set Border to Solid line, its Color to orange and its Width to 0.75 pt.ħ. In the Format Data Series pane click on the Fill & Line icon. Then, right-click the Series “Highlighted” data series and then, on the shortcut menu, click Format Data Series.Ħ. Next, In the chart area, select the Series “Highlighted” data series and paste the shape by pressing Ctrl + V.ĥ. In the chart area, select the Series “y” data series and paste the shape by pressing Ctrl + V.Ĥ. Copy the newly created shape to the clipboard by pressing Ctrl + C.ģ. Draw a short vertical line-say 0.3 in height-anywhere on the worksheet using the Shapes in the Illustration Group under the Insert Tab.Ģ. The chart can be easily transformed into a Barcode Plot as follows:ġ.
0 kommentar(er)
