Chapter 21: Using Advanced Charting Techniques
21
Standard deviation(s) The error bars are in the number of standard deviation units that
you specify. (Excel calculates the standard deviation of the data series.)
Standard error The error bars are one standard error unit. (Excel calculates the standard
error of the data series.)
Custom You set the error bar units for the upper or lower error bars. You can enter either
a value or a range reference that holds the error values that you want to plot as error bars.The chart shown in Figure 21.25 displays error bars based on percentage.FIGURE 21.25
This line chart series displays error bars based on percentage.A data series in an XY chart can have error bars for both the X values and the Y values.
A workbook with several other error bar examples is available on this book’s website at http://www.wiley
.com/go/excel2019bible. The filename is error bars example.xlsx.Adding a trendline
When you’re plotting data over time, you may want to display a trendline that describes
the data. A trendline points out general trends in your data. In some cases, you can forecast
future data with trendlines.To add a trendline, select the data series and click the Add Elements button to the right of
the chart. Place a check mark next to Trendline.