+ Reply to Thread
Results 1 to 2 of 2

stacked bar chart with dates?

  1. #1
    Registered User
    Join Date
    04-11-2017
    Location
    Durham, NC
    MS-Off Ver
    2016
    Posts
    1

    Question stacked bar chart with dates?

    Hi all,

    Thanks for creating this excellent resource.

    I am trying to create a stacked bar chart that shows multiple stages of 5-10 different projects over the course of the next year. My attempts to do so have fallen short! Specifically:

    * Each bar (horizontal) should represent a project.
    * Each bar should have multiple segments, each of which represents a stage in the project (stage 1, stage 2, stage 3, etc.).
    * The data for each segment should be a range of dates.

    Any suggestions, templates, examples would be greatly appreciated!

    Thank you.

    Scott

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

    Re: stacked bar chart with dates?

    What you describe sounds like a variation on a Gantt chart. I would start by creating a basic Gantt chart (help file here: https://support.office.com/en-us/art...rs=en-US&ad=US ), which is basically a variation on a stacked bar chart, then add the additional data series to represent each stage of your projects.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] Dates by Month on X-Axis in Horizontal Stacked Bar Chart
    By Bandolier2k in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-16-2018, 11:02 PM
  2. Stacked Bar Chart with horizontal axis as dates
    By BrianSX in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-31-2017, 11:22 PM
  3. [SOLVED] Stacked Horizontal Bar Chart / Help with Dates
    By Ciwan in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 10-11-2013, 08:23 AM
  4. Replies: 2
    Last Post: 11-02-2011, 12:49 PM
  5. Stacked Column chart that groups dates by month
    By bigban in forum Excel General
    Replies: 2
    Last Post: 07-08-2011, 05:37 AM
  6. Replies: 2
    Last Post: 09-28-2010, 07:29 AM
  7. Stacked Bar Chart using Dates as my data
    By kdestef1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2010, 07:54 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