Is it possible to give the error bar chart a y-scale range (from...to), so that it does not start from 0? I am trying to implement a basic chart that shows the range of data, as in candlestick (for instance, 99 to 356), show it's mean/average (for instance, 230) and need to show the error (or standard deviation) via error whiskers (for instance, 40 up/down). It would be great to show these values on chart (and also the ability to move them off-center a few pixels, so that they are not crossed by error, etc. lines). I could use the candle to show mix/min, and average (open/close with the same value), but it would not give me the error whiskers. I could use the error bar chart, but it would not give me the range, just the column for average, which by itself without the data range is useless. I could use the stacked bar to show this data as "bands," but then I would have to play with the bottom bar (from 0 to the lowest range value) being clear, etc.
Any solutions or ideas that would allow me to make this simple chart without head-banging?
Thanks!
