Recipe 4-14. Displaying Error Bars

Table of contents:

Displaying Error Bars

Problem

You want to display error bars on data series in your charts.

Solution

You can display error bars for a series by opening the Format Data Series dialog box. Select the series and press Ctrl-1. Click the Y Error Bars tab to specify how you'd like the error bars displayed. You can choose to display plus or minus bars or both. Further, you can specify the error as a fixed value, a percentage of the value being plotted, or as custom values in a cell range you provide. Figure 4-20 (in Recipe 4.9) shows an example data series with error bars.

Using Excel

Getting Acquainted with Visual Basic for Applications

Collecting and Cleaning Up Data

Charting

Statistical Analysis

Time Series Analysis

Mathematical Functions

Curve Fitting and Regression

Solving Equations

Numerical Integration and Differentiation

Solving Ordinary Differential Equations

Solving Partial Differential Equations

Performing Optimization Analyses in Excel

Introduction to Financial Calculations

Index



Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net