Calculated Error Bars?
I have a spreadsheet containing 93 columns, of which 30 are standard
deviations on the means stored in other columns. I have code to generate a range of graphs from this, and I want to show two standard deviations as error bars. I can show ONE standard deviation simply by selecting the column, but nothing I've yet tried has worked to double this. I kinda hoped a simple *2 screwed on the end would do the trick, but no dice. As I said, I have 30 columns like this, and I really don't want to add another 30 columns just to double the 30 I have. Likewise, I don't want to mess with the content of the 30, as it reduces flexibility and repeatability. So, is there any way that I can use a formula to set error bars to twice the value of a column? Robert Smith |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com