Inside Microsoft Excel

Allow for some degree of error in your chart’s data

Inside Microsoft Excel

by Frank Kuhn

A graph of statistical data can get tricky, if not misleading, in that Excel’s default chart settings won’t automatically display the degree of uncertainty in your graph. Fortunately, Excel allows you to communicate variability and uncertainty within your graphs with error bars, as shown inĀ Figure A. In this article, we’ll introduce you to error bars and show you how to use them to make sure your charts accurately describe the data or[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)