+ Reply to Thread
Results 1 to 4 of 4

Advanced Histogram

  1. #1
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Advanced Histogram

    Dear Excel Pros!

    I want to make a histogram that shows how many tasks I have completed for different companies over a period of three years.

    The X-axis should show the different years; one column for 2011, one for 2012 and one for 2013. The Y-axis should contain the numbers of completed tasks.

    I want the information from each of the companies to be stacked on top of each other (please see the attached example). If this is not possible, the information should be grouped beside each other and separated for each year.


    Note: in the Excel file the Y-axis is not correct (should be from 0 - 230). The X-axis should contain the remaining years as well...


    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Advanced Histogram

    In sheet1 I just rearragend the data and selected it for the graph
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Re: Advanced Histogram

    Thank you! That solved me for a lot of work!

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Advanced Histogram

    you are welcome. please mark the thread as solved..

+ 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. Histogram cumulative 20% of the distribution
    By aekrohm in forum Excel General
    Replies: 1
    Last Post: 02-03-2012, 02:15 AM
  2. Histogram
    By jw01 in forum Excel General
    Replies: 3
    Last Post: 02-17-2011, 08:17 AM
  3. Histogram
    By msgreen822 in forum Excel General
    Replies: 1
    Last Post: 12-16-2010, 06:25 PM
  4. Superimposed histogram A on histogram B
    By firuz in forum Excel General
    Replies: 5
    Last Post: 05-26-2007, 09:10 PM
  5. Replies: 2
    Last Post: 07-21-2006, 10:05 AM
  6. 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
  7. [SOLVED] Histogram?
    By Tom in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-26-2006, 09:40 PM
  8. 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

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