I'm a university teacher for physics and electronics. I posted this as a bug with the (german) feedback tool of my office 365 (the bug also exists in office 2013), but hope for no reaction from microsoft. Choose Error Bars.Alternatively, click on the graph and then go to the Chart Design tab and select AddChart. The expected value would be to not draw the affected error bars at all, or, more correct, draw a vertical line from the error cap to the lower end of the diagram. The Format Data Series box will pop open. This variable contains an arbitrary number if the invlaid point is the first point, and the coordinates of the last valid point for the further invalid points. Obviously, there is an uninitialized variable in the Excel source code, if a data point is not vaid, but excel still uses these coordinates to draw the error bar. The error bar cap of point 1 is connected with some random point, which even moves if the zoom factor or number format in some other part of the sheet is changed. At that location a error bar cap is plotted, but it is connected with a diagonal line with the LAST VALID DATA POINT. For the other points, the y-value is not plotable. In fact, only Point 2 can be plotted in a straightforward way. Error bars in Logarithmic plots end at wrong data points wenn some values are 0 or negative.ġst column is x, 2nd y, 3rd y errors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |