Results 1 to 10 of 10

Stacked Histogram?

Threaded View

  1. #6
    Registered User
    Join Date
    09-22-2016
    Location
    California, USA
    MS-Off Ver
    2016 Excel
    Posts
    7

    Re: Stacked Histogram?

    I used the format type specified above.

    The x and y axis are still not correctly representing what I truly want.
    I'll attach the data on this post. I am giving Excel a lot less information than I should be.

    y-axis should contain whole integers representative of a claim saying "10 screws were made that were within this range". The x-axis should contain that range (20-22mm or whatever it is). Ultimately, I would be able to make a claim saying.. "10 screws were made within 20-22mm, 7 within 22-24mm etc etc". The importance of the stacking is that I can see how each specific machine contributes to the total number of screws made within that range.

    Thanks, I don't think I've ever spent this long trying to make a silly graph...

    PS: couldn't attach the Excel file for some reason - so sent it via pictureexample.JPG

    Conversely, a histogram gives the correct x and y axis. However, even with all data selected, it only graphs one column of data - the other columns are hidden behind it.
    Note that the y axis is counting the number of times a value (in this case of type 1) falls between the ranges on the x axis. If I change those x axis ranges in the excel options, the y axis count changes accordingly. This is exactly what I want, but I want to stack all of the machine Types! frustrating stuff
    example2.JPG
    Last edited by jgodfrey; 09-23-2016 at 01:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining a Column histogram with a stacked column in a single chart
    By Mythicos in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-25-2016, 12:40 PM
  2. Stacked... histogram?
    By mrtaufiq in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-22-2013, 07:56 AM
  3. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  4. Superimposed histogram A on histogram B
    By firuz in forum Excel General
    Replies: 5
    Last Post: 05-26-2007, 09:10 PM
  5. [SOLVED] I was creating a histogram; now i have data but no histogram.
    By ShannonMills3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-13-2006, 07:10 PM
  6. 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
  7. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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