To hide the horizontal error bars, set Percentage to 0.Click the horizontal error bar and do one of the following:.Change Direction to Minus for the vertical line to go only downwards from the data point.
Set Direction to Both if you'd like the vertical line to go upwards and downwards from the data point.Depending on your needs, set Direction to one of the following: On the Format Error Bars pane, switch to the Error Bar Options tab (the last one) and set Percentage to 100.Right-click on the vertical error bar and choose Format Error Bars… from the context menu.Select the new data point in your chart (orange in our case) and add the Percentage error bars to it ( Chart Elements button > Error Bars > Percentage).Otherwise, the selected x and/or y cell will be added to the existing array, which will lead to an error.
Be sure to delete the existing contents of the Series values boxes first - usually a one element array like =.