View original (French)

Chart with standard deviation in Excel

Solved
Chabrier38 Posted messages 5 Status Member -  
Chabrier38 Posted messages 5 Status Member -
Hello,

I saw some messages explaining how to create bar charts with standard deviations in Excel, but I need to do this on a curve (evolution over time). Can you tell me how to do that? Thank you very much in advance!

Configuration: Windows / Internet Explorer 11.0

1 answer

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    Whether it's a curve or a histogram, the process is the same.
    Select the data series >> Format the data series >> Y error bar.
    -If the standard deviation value is the same for all points, check Standard deviation.
    -Otherwise, choose custom value and fill in the fields in the input boxes. You will need to have calculated the standard deviations in 1 or 2 columns beforehand.
    0
    1. Chabrier38 Posted messages 5 Status Member
       
      Thank you for your response. I had indeed tried, as I had seen the answers for the histograms. So I continued to look in that direction
      Finally, by clicking on my curve as you told me, I realized that the chart tools menu appears. By opening the layout menu -> analysis -> I unfolded the error bars tab -> more error bar options and there, a window opens like the one you mentioned, where you can choose custom value and copy the values I had for my standard deviations
      Thank you
      0