Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Constructing a histogram in Excel 2010

    Hi,

    I have Excel 2010 and I would like to construct a histogram. The intervals and corresponding frequencies are as follows:

    Intervals Frequency

    [100-110); 8
    [110-120); 1
    [120-130); 3
    [130-140); 3
    [140-150) ;7
    [150-160); 5

    How would I construct this frequency distribution bar graph?

    Thank you.
    Last edited by moon1130; 2012-04-25 at 21:52.

  2. #2
    Lounger
    Join Date
    Apr 2012
    Location
    Abergavenny, Wales, UK
    Posts
    25
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Hi

    Just highlight your set of data > Insert tab > Column > 2d Column
    See attached workbook


    Regards
    Roger Govier
    Microsoft Excel MVP
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts
    Hi Roger,

    Thanks for your response and help. The attachment was very helpful.

    Regards,

    Moon

Posting Permissions

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