+ Reply to Thread
Results 1 to 7 of 7

Histogram bins not working

  1. #1
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    62

    Histogram bins not working

    I have a column of data which is a Likert scale of 1 to 4 and I want to make a histogram of how frequent each rating occurs.

    I selected the column to generate a histogram, with another column with values 1,2,3,4 as the bins.

    However, when the histogram is generated, the table showing the bins and frequency does not show 1,2,3,4 but I get numbers such as 1.079, 1.158, 1.237 and so on. I am following the exact same instructions I find on various tutorials.

    I also followed the troubleshooting guide using a quick search but I don't see the Bins settings under axis options.

    Need help setting bins to whole numbers 1,2,3,4
    Last edited by Cheesecube; 03-20-2018 at 07:19 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,150

    Re: Histogram bins not working

    If you use Analysis Toolpack then you prabably were not successfull to show proper range with bins.

    May be you could attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    62

    Re: Histogram bins not working

    Ok it seems while doing up the demo I realized that the histogram works when the bin is on the same sheet as the data

    However, I need the bin to be on a separate sheet. Any idea how to make this work?

  4. #4
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    62

    Re: Histogram bins not working

    See attached file for troubleshooting. I'm using roughly the same data and bins in the troubleshooting file, but I get a different result in the demo file and the actual document.
    Attached Files Attached Files

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Histogram bins not working

    Hi,

    Select the Bins sheet before invoking the Histogram tool.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  6. #6
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    62

    Re: Histogram bins not working

    Thanks! That sorted it out. Just curious - what caused this error?

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Histogram bins not working

    The programming in the ATP add-in doesn't include workbook/sheet information for the bin range address, but it does for the input range.

+ 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. Replies: 1
    Last Post: 12-26-2017, 09:51 AM
  2. Replies: 5
    Last Post: 11-26-2014, 09:26 PM
  3. How do I build a histogram with two bins?
    By flyboy54 in forum Excel General
    Replies: 0
    Last Post: 10-10-2012, 05:44 PM
  4. Replies: 10
    Last Post: 09-18-2012, 10:33 AM
  5. Automatically Regenerate Histogram Bins By/Via Data Analysis Toolpak
    By splendidus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2012, 06:58 AM
  6. Using BINS in Excel 2007 (not for histogram)
    By jon.kuhn in forum Excel General
    Replies: 2
    Last Post: 05-08-2012, 06:06 AM
  7. [SOLVED] Histogram Bins Created From Sum Of Two Cells
    By pdberger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2005, 03:05 PM

Tags for this Thread

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