Y-Error Bars - only need one

[Diana]

I am having trouble putting a y-error bar on one data
point in my series. Excel wants to add error bars to all
points (bars) in the series. Is there a way to do this?
Thanks.

 

[Andy Pope]

Hi Diana,

To get error bars on a single bar you can use the Custom +/- reference
boxes on the Error bar tabs. Use this to get your values from worksheets
cells.
Obviously within the cells are zero values for all but the bar your want.

Cheers
Andy