Standard deviation in Excel

Solved
Hello,
I would like to create a chart in Excel and I want the standard deviations to be visible. I have already calculated them, but I don't know how to display them on the graph.

Thank you for your help.
Configuration: Windows 2000 Internet Explorer 6.0

18 answers

  • Votes
  • Date
  • Descending date
  1. Hello,

    I would like to add a reply now because I think the previous responses did not solve the issue by displaying the same standard deviation for all the bars in the histogram. Here is the solution that I think is correct:

    Once the histogram is created:
    calculate the standard deviation for each data point in your spreadsheet: =STDEV(values series)
    right-click on the bars and click on "format data series"
    go to the "Y error bar" tab
    In "error amount" select "custom"
    In the "+" box, select all your standard deviations
    In the "-" box, select all your standard deviations

    And now each standard deviation displayed corresponds to each entry in your histogram and is therefore not constant for each bar.

    Have a nice day.
    1. ...I didn't ask and you answered me, thank you.
    2. Very precise answer! Thank you very much.
    3. Thank you very much! Your help has been invaluable to me!
    4. Thank you very much! Great info! :-)
    5. Thank you for this post! It's very helpful to me today!