Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2005
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bell Curve on Graph (2003)

    I am trying to incorporate a bell curve on top of a bar chart that has # of people on the X and amount of hours worked on the Y. Can anyone help me please? Thanks, Norma

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bell Curve on Graph (2003)

    If you have the original data you can compute the avarage and standard deviation easily, and use this to calculate the normalized distribution of the data. See attached example.
    Attached Files Attached Files

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bell Curve on Graph (2003)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>In a case like this I would recommend that the line be formatted and have the "Smoothed Line" checked ...

    Steve

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bell Curve on Graph (2003)

    Yep, good idea.

  5. #5
    Lounger
    Join Date
    Jan 2005
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bell Curve on Graph (2003)

    Thank you for your suggestion. I now see that we were using a stacked bar chart from several series of data and that was causing the problem. Thanks again, Norma

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •