+ Reply to Thread
Results 1 to 4 of 4

Stacked bar chart

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    33

    Stacked bar chart

    I'm trying to do a stacked bar chart with dates. What I want to accomplish is to have the end of the bars end on the indicated dates with later dates essentially jus showing the difference. The first set of data is showing properly, but the second set of data is just flooding out of the chart and not ending on the date indicated. Any thoughts? Also attached is my sample data which I'm pulling from. So I'm trying to use this chart as a simple way to visualize the potential impact different dates have on the schedule.

    Screenshot at Sep 12 10-32-33.png

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,850

    Re: Stacked bar chart

    No data attached, and the picture doesn't allow us to see what values are being used for the orange bars. My guess is that the orange bars currently represent the desired end date rather than the difference between the gray bar's date and the desired end date.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Stacked bar chart

    My bad, here it is.

    Screenshot at Sep 12 10-34-27.png

    So for example one grey bar shows end date of 7/29, and the current forecast of 8/31 so I'd only want that orange bar to show a small sliver and ending on 8/31. Then from there if the actual release date is 9/13 for example, then another sliver of a bar on the same row showing the actual release date.
    Last edited by smockpuv; 09-12-2022 at 12:43 PM.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,850

    Re: Stacked bar chart

    Assuming that picture is the complete data set being used by the chart, I do not see a difference column calculating the differences between dates. You will need to calculate a difference column for the orange bars.

+ 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. [SOLVED] Combine stacked columns and stacked bars in a chart
    By maboho93 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-09-2018, 07:52 AM
  2. Replies: 5
    Last Post: 12-09-2015, 12:41 PM
  3. Stacked bar chart with stacked secondary axis markers - please help!
    By Boardlady in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-22-2013, 10:32 AM
  4. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  5. How can I combine a stacked bar chart with stacked colum chart?
    By Sin in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 12-19-2005, 11:55 PM
  6. Replies: 1
    Last Post: 03-26-2005, 02:06 PM
  7. 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

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