View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Calculate and display standard error

Hi,

On the Y Error Bars tab of the format dialog is the option to define
custom +/- values. These can be linked directly to the computed values
you already have.

See Jon Peltier's explanation.
http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

Cheers
Andy

harrynatick wrote:
I can see how to add standard error indicators to a line graph, and I can
certainly computer standard errors for my data, but how does one connect the
two? That is how can one display computed standard error bars above and below
data points?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info