Lets say you have 100+/-120

in non logaritmic scale, you should have an error bar starting at -20
if you put that as a log, then you have an error because you cannot
calculate the log of a negative or null value. And thus excel is lost.
No solution than to change the data !

Misange migrateuse
http://www.excelabo.net


smmudge a écrit :
I have a somewhat related issue with Log axes graphs...

If I add error bars to data and display them with a linear y-axis, all is
well. If I convert the y-axis to log, some of the bars (not all) are not
finished correctly and Excel draws triangles to the next error bar.

Is there a work around for this?

Thanks. Steve