locked
Creating a Bell Curve in Excel RRS feed

  • Question

  • Attempting to create a bell curve in excel 2016 spreadsheet as per the instruction on https://support.microsoft.com/en-us/help/213930/xl-how-to-create-a-bell-curve-chart.

    I am getting stuck on step #16, which requires me to "Click the Series Tab" in order to progress to step #17 that requires "In the Name box, delete the cell reference, and then select cell E15". This is frustrating because there are 31 steps.  Does anyone know why there may not be a simple way of finding the SERIES TAB?

    Regards,

    Someone10

    Saturday, April 15, 2017 4:08 AM

Answers

  • The formula in the ExtendOffice article is

    =NORM.DIST(A2,$C$2,$D$2,FALSE)

    not

    =NORMS.DIST(A2,$C$2,$D$2,FALSE)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Someone10 Wednesday, April 19, 2017 2:02 AM
    Saturday, April 15, 2017 3:38 PM

All replies

  • Those instructions are for Excel 97 and Excel 2000. Excel 2016 has a different interface and treats charts differently.

    See https://www.techwalla.com/articles/how-to-use-excel-to-create-a-bell-curve or https://www.extendoffice.com/documents/excel/2404-excel-template-bell-curve-chart.html for instructions for Excel 2013, which is virtually identical to Excel 2016 in operation.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Saturday, April 15, 2017 9:43 AM
  • Does one need a special add in for  =NORMS.DIST(A2,$C$2,$D$2,FALSE) in step 4 from the www.extendoffice.com hyperlink? A #NAME error results in Cell B2. When I begin to type NORMS into the cell it isn't recognized with the period between NORMS and DIST only recognized as NORMSDIST. When I use this one without the period another error shows up that reads "You've entered too many arguments for this function".

    Someone10

    Saturday, April 15, 2017 2:41 PM
  • The formula in the ExtendOffice article is

    =NORM.DIST(A2,$C$2,$D$2,FALSE)

    not

    =NORMS.DIST(A2,$C$2,$D$2,FALSE)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Someone10 Wednesday, April 19, 2017 2:02 AM
    Saturday, April 15, 2017 3:38 PM
  • Can't believe I didn't see that. Thanks.
    Sunday, April 16, 2017 12:15 AM
  • Hi Someone10,

    Great tot see that your issue has been resolved :)

    Could you please help mark the useful reply above provided by Hans as answer then it will be easier for other community members who have similar issues to find the resolution?

    Your understanding and cooperating is really appreciated.

    Best regards,
    Yuki Sun


    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, April 17, 2017 3:06 AM