+ Reply to Thread
Results 1 to 2 of 2

Histogram - One giant bin, can't make more.

  1. #1
    Registered User
    Join Date
    09-20-2017
    Location
    Avon, OH
    MS-Off Ver
    Excel 2016
    Posts
    1

    Histogram - One giant bin, can't make more.

    Trying to make a histogram for my statistics course, here's what happens.

    1. I select top of column, hit control, drap down to select all data I need
    2. Go to histogram
    3. Histogram pops up as a giant blue block, with measured data on x axis and frequency on y axis (backwards)
    4. When I go to make changes and change from "automatic" to "by category" to correct this, the "bin" and "bin width" go dark and I can't change them.

    It's as if it's either only using one data point, or has the X and Y axis backwards, and I don't know how to change it.

    Can anyone help???

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Histogram - One giant bin, can't make more.

    Maybe try with Data - Data Analysis - Histogram

    Hard to say something more without attached example excel file

+ 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: 08-25-2016, 12:52 AM
  2. Replies: 3
    Last Post: 05-01-2013, 07:04 PM
  3. [SOLVED] How to Histogram w/o raw data but histogram Table on Excel
    By 2005 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2006, 02:50 AM
  4. how to make a histogram with frequency
    By hannah553 in forum Excel General
    Replies: 1
    Last Post: 01-15-2006, 02:10 PM
  5. [SOLVED] Make Histogram and Normal distribution.
    By Ed (from UK and useless with comuters!) in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-19-2005, 02:10 PM
  6. Need to make a plain barchart, not a histogram
    By penguinchick in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2005, 07:05 PM
  7. How to make excel not round real numbers when making a histogram?
    By Leedawg in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2005, 03:05 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