Share via

Negative error bars are not showing in excel line graphs

Anonymous
2018-02-22T04:50:43+00:00

Hi I am presenting one of my works at one of the prestigious institutes and stuck in the developing negative error bars for a line graph.

It only shows the positive error bars. Please help ASAP. 

Thanks

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2018-02-22T13:34:11+00:00

    Your mistake was in using negative numbers for the 'down bars'

    Excel knows the negative ones go down and subtracts the error bar data from the data point value

    If the pos and neg error bars are the same you can get away with one column of values

    best wishes

    8 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-02-23T02:01:17+00:00

    Thanks heaps Bernard. I was just stuck there :)

    1 person found this answer helpful.
    0 comments