Add Change Or Remove Error Bars In Chart. Select the added series click the plus icon next to the chart and check Error Bars below left. Changing Chart Display Options.
On the PivotChart toolbar click Properties and then click the General tab. In Excel Outlook PowerPoint or Word for Windows and Mac you can format add change or remove error bars in a chart. Change the display of chart axes.
Click the chart that you want to add error bar then it will active the Chart Tools in Ribbon.
Then select the horizontal error bars press Ctrl1 and in the Format Error Bars task pane under Error Amount select Custom and click the Specify Value button. Right-click the axis in the view and select Add Reference Line. With the graph window active click Insert and then click Add Error Bars. For Band From in the Value dropdown select AGGSales lower bar.
