+ Reply to Thread
Results 1 to 2 of 2

Multiple bell curves based on data range

  1. #1
    Registered User
    Join Date
    06-15-2011
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2013
    Posts
    4

    Multiple bell curves based on data range

    I need to create multiple based curves for a set of values per group (A-G), both as separate charts and (if possible) in the same chart.
    The groups and the corresponding sets of values per group can be found below, as well as on the attached file.
    Thank you in advance!

    Group Change Curve
    A 0,0%
    A 0,0%
    A 0,0%
    A 0,0%
    A 0,0%
    A 21,1%
    A 10,7%
    A 0,0%
    A 7,0%
    A 7,0%
    A 0,0%
    A 0,0%
    A 0,0%
    B 4,0%
    C 0,0%
    C 5,0%
    D 0,0%
    D 0,0%
    D 3,5%
    D 2,5%
    D 3,5%
    E 0,0%
    E 0,0%
    E 3,0%
    E 0,0%
    E 0,0%
    E 0,0%
    E 0,0%
    E 4,0%
    E 0,0%
    E 0,0%
    E 0,0%
    E 0,0%
    E 3,5%
    E 2,5%
    E 2,5%
    E 2,5%
    E 3,0%
    E 0,0%
    E 0,0%
    E 3,5%
    E 0,0%
    E 3,5%
    E 0,0%
    E 0,0%
    E 4,0%
    E 0,0%
    F 0,0%
    F 0,0%
    F 0,0%
    F 0,0%
    F 8,3%
    G 0,0%
    G 6,0%
    G 0,0%
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Multiple bell curves based on data range

    This looks like it could be solved with a pivot table. First I converted the data range into an Excel Table. This way if the scope of the data changes (rows are added or deleted), the pivot table will react accordingly. Then I set up the pivot table as shown and plotted it as a column chart.

    I inserted a slicer only because it looks impressive and it is the easiest way to filter pivot table items. You can select a single group or multiple groups or clear the filter to show all groups.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with creating bell curves
    By Sightburner in forum Excel General
    Replies: 6
    Last Post: 05-04-2016, 05:57 PM
  2. [SOLVED] Multiple curves on the same graph
    By MarmaladeLover in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-29-2014, 12:38 PM
  3. Help Regarding Normal Distributions and Bell Curves
    By Euriah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2012, 12:17 PM
  4. Comparative Charting (Bell Curves?)
    By Mordred in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-05-2011, 11:31 AM
  5. Excel Charts - Need Help Creating Bell Curves
    By hrm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2009, 04:56 PM
  6. Created bell curve, do not understand the curves i created
    By Phokus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-22-2008, 09:16 AM
  7. multiple lines / curves on scatter chart?
    By lightecho in forum Excel General
    Replies: 1
    Last Post: 09-03-2007, 12:19 PM

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