View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Smith[_2_] Robert Smith[_2_] is offline
external usenet poster
 
Posts: 1
Default 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