Error bar detection fails if series is not contiguous
Data analysis and visualization for Excel, for free
Brought to you by:
bovender
Menu
▾
▴
#24 Error bar detection fails if series is not contiguous
I'm attempting to use XL Toolbox 4.01 with Office 2010 to detect error bar values which are immediately below the cell containing the graphed value, but the graphed data series is not contiguous. For example, in A1:A4 are values, in A5 is the average of A1:A4 and in A6 is the stdev of A1:A4. The B column is blank. In C1:C4 are values, C5 is he average of C1:C4 and C6 is the stdev of C1:C4. The graph is: =SERIES(,,(Sheet1!$A$5,Sheet1!$C$5),1)
Both automatic detection modes fail to detect the error bar values in A6 and C6. If I use the standard mode with offset mode set to 1, cells A7 and C7 are selected. If the advanced detection is used, A12 and C12 are selected.
Deleting the B column to make the graphed series contiguous does not solve the problem. However, deleting the B column and then recreating the graph causes the standard detection mode to correctly detecting the stdevs in A6 and B6. The advanced mode still incorrectly detects cells in A12 and B12.
I realize that the advanced mode isn't functioning regardless due to the lack of empty cells, but shouldn't the standard mode work under both circumstances?
You are right that standard mode should work. Haven't had time this morning to test it on my machine, but I am currently finishing a major rework of the error bar algorithm anyway and will consider your situation as well! There should be a new release later this month (hopefully!!).
There's a beta version now at http://sourceforge.net/projects/xltoolbox/files/beta/XL_Toolbox_4.08.exe/download which has had the error bar algorithm reworked. It should be able to handle your charts without problems now. There may be some rough edges still, so I'd appreciate some feedback. Get the beta at http://sf.net/projects/xltoolbox/files/beta/XL_Toolbox_4.08.exe/download