Share via

Error Bars in log axis

Anonymous
2011-02-01T23:59:47+00:00

Excel 2007.  I could add error bars in linear scales but then when I change the axis to log, large black panels appear on the graph.  How do I avoid this?

This does not happen in other versions of Excel I have tried.  But I do not want to redo all my graphs in a different version of Excel.

thanks

b

Microsoft 365 and Office | Excel | For home | Windows

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

HansV 462.6K Reputation points
2011-02-02T08:41:07+00:00

Make sure that no values less than or equal to zero are involved - those can't be plotted on a logarithmic axis. For example if y = 0.5 and you have error bars for +1/-1, the min would be -0.5.

I found one recommendation to create the error bars BEFORE changing the axis to logarithmic...

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2011-05-09T05:45:27+00:00

    If you have zero values, you cannot use a logarithmic axis.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-05-09T00:13:30+00:00

    Is there any other way to remove these as I am having the same problem but I have to use values of zero!!!

    Thanks

    Was this answer helpful?

    0 comments