In the chart, select the data series that you want to add error bars to. On the Chart Design tab, click Add Chart Element, and then click More Error Bars Options.

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

Arguments that are error values or text that cannot be translated into numbers cause errors. If you want to include logical values and text representations of numbers in a reference as part of the calculation, …

Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements and terms.

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

At first, the chart doesn't yet resemble a box plot, as Excel draws stacked columns by default from horizontal and not vertical data sets. To reverse the chart axes, right-click on the chart, and click …

You can add predefined lines or bars to charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the …

You can apply visual effects (such as a shadow, glow, or bevel effects) to selected shapes (such as data markers, titles, data labels, or a legend) and lines (such as gridlines, axes, trendlines, or error bars).

By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Some add-ins are built in to Excel, such as Solver …