+ Reply to Thread
Results 1 to 7 of 7

How to chart 2 stacked bars per day?

  1. #1
    Registered User
    Join Date
    12-18-2003
    Location
    Missouri
    Posts
    62

    How to chart 2 stacked bars per day?

    I have four columns:

    Ready Line, In-Process Lines, Ready Items, In-Process Items

    Each has a value (0-200) for each day of the month.
    This makes the data table for February 20 rows.

    I want to graph the Ready and In-Process Lines stacked in one bar,
    and the Ready and In-Process Items stacked in a separate bar,
    so the graph will have two stacked bars per day.

    Regardless of how I organize the data, or add empty columns,
    or empty rows in between,
    I always end up with a one stacked bar per day with all four values.

    I looked at the link PTS Blog on clustered-stacked column charts,
    but could not solve my problem.

    Any help will be appreciated,

    Alex
    Last edited by Ingeniero1; 02-24-2009 at 12:13 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,180

    Re: How to chart 2 stacked bars per day?

    Why did Jon's information on cluster/stacked columns not solve your problem?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-18-2003
    Location
    Missouri
    Posts
    62

    Re: How to chart 2 stacked bars per day?

    Andy,

    Because after following the recommendations given, "Regardless of how I
    organize the data, or add empty columns, or empty rows in between,
    I always end up with a one stacked bar per day with all four values."

    What I need is to have two stacked columns per day:
    Stacked Column No. 1 consisting of: Ready Lines and In-Process Lines
    Stacked Column No. 2 consisting of: Ready Items and In-Process Items

    Instead, what I get is a single stacked column consisting of all four values.

    Thank you for following up and for any further help.

    Alex

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,180

    Re: How to chart 2 stacked bars per day?

    Can you post example workbook

  5. #5
    Registered User
    Join Date
    12-18-2003
    Location
    Missouri
    Posts
    62

    Re: How to chart 2 stacked bars per day?

    Andy,
    In the attached workbook I show the four data entries per day:
    (order lines) In-process and Ready; (line items) In-process and Ready

    Underneath the data table I show how I would like to have the stacked bars represent the data for each day; namely, In-process and Ready lines on the first stack, and in-process and ready Items on the second stack.

    Thanks for your time and help,

    Alex
    Attached Files Attached Files

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,180

    Re: How to chart 2 stacked bars per day?

    You need to lay your data out as done in the attached.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    12-18-2003
    Location
    Missouri
    Posts
    62

    Re: How to chart 2 stacked bars per day?

    Andy,

    Thank you, thank you, thank you!

    I had added empty columns between the columns with data, and that did not work.
    I had then added empty rows between the rows with data, but that did not work either - - - because, as I see now, I did not alternate them as you did.

    This works great.

    Thanks again,

    Alex

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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