+ Reply to Thread
Results 1 to 3 of 3

How can I add a Gaussian curve to a histogram on Excel?

  1. #1
    JC1379
    Guest

    How can I add a Gaussian curve to a histogram on Excel?

    Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I
    dont know how. Any tips or advice?

    Thanks

  2. #2
    Barb Reinhardt
    Guest

    Re: How can I add a Gaussian curve to a histogram on Excel?

    This may help

    http://www.tushar-mehta.com/excel/ch..._distribution/


    "JC1379" <JC1379@discussions.microsoft.com> wrote in message
    news:84D0DD10-8875-4932-A733-AD3BE75CD920@microsoft.com...
    > Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I
    > dont know how. Any tips or advice?
    >
    > Thanks




  3. #3
    Mike Middleton
    Guest

    Re: How can I add a Gaussian curve to a histogram on Excel?

    JC1379 -

    > Trying to add a Gaussian (Normal Distribution) curve to a histogram, but I
    > dont know how. Any tips or advice? <


    One way is to use a combination chart, with a Column chart type for the
    vertical histogram bars and an XY (Scatter) chart type for the normal
    density curve.

    You could start with the chart generated by my free Better Histogram add-in,
    available at www.treeplan.com, which produces a combination chart (so that
    the horizontal axis is more properly labeled), and then you could change
    that chart's XY (Scatter) data series to be based on worksheet data using
    NORMDIST for the curve. You must be careful about scaling so that the Column
    chart type and the XY (Scatter) chart type are aligned correctly.

    - Mike
    www.mikemiddleton.com



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1