Microsoft Office Tutorials and References
In Depth Information
Connecting data points to the axes with error bars
The companion CD-ROM contains an additional example that draws
squares around data points.
Connecting data points to the axes with error bars
The example in Figure 8-34 shows an XY chart in which each data point is
projected to the x and y axis. These lines are created with error bars. Access the Format
Data series dialog box and use the X Error Bars tab and the Y Error Bars tab to add
the error bars.
In this example, X error bars are set to use the X data range (Custom negative
option), and the Y error bars are set to use the Y data range (Custom positive option).
Figure 8-34: Using error bars to project each data point to the axes
Connecting XY points to the origin
The chart in Figure 8-35 shows an XY chart in which each data point is connected
to the origin. This type of chart requires an additional series for each data point.
The chart shown in the figure displays five data points, and the chart has six data
series.
The first series uses the data in B3:C7, and this series is set to display markers
(but no line) and data labels. Each data point has an additional series displayed as
a dashed line. For example, the first data point uses the values in B10:C11. Note
that each of these additional series consists of two data points that connect the
original data point with the chart’s origin (0,0). You can, of course, use any other
XY pair in place of 0,0.
Search JabSto ::




Custom Search