+ Reply to Thread
Results 1 to 6 of 6

Bar Graph/Gantt Chart

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    London, England.
    MS-Off Ver
    Excel 2010
    Posts
    2

    Bar Graph/Gantt Chart

    Hi everyone,

    I'm wondering if anyone can offer some insight into a conundrum I am having with Excel. I wish to create a bar graph/gantt chart, which displays months along the X axis, and each point in the Y axis represents a dataset.
    The dataset represents stages, which I wish to colour code.

    I've attached a very rough example, though I'm having trouble with the majority of it.

    http://i.imgur.com/PwslU.jpg

    Although there will be more sets of data, this serves as an example of what I am after. In order to do this one, I had to select each chunk and colour code them accordingly. However, the legend was incorrect.

    From the example, I would like the X axis to represent months. From October 2010, to October 2012.
    And each coloured block represents a stage (though I am after 5 stages/colours).

    Not all data rows begin and end on the same month, however. Is it possible for me to create what I am after?

    If you require any more details, please feel free to ask. And, thank you for taking the time to help.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    11-30-2011
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Bar Graph/Gantt Chart

    Hi Bob,

    you should use a stacked bar chart and make some of the series transparent.
    Have a look at this sample with floating bars which is set up in a similar way:
    http://www.pimpmychart.com/english/d...0559f8e1287701

    Regards

    Holger

  3. #3
    Registered User
    Join Date
    05-31-2012
    Location
    London, England.
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Bar Graph/Gantt Chart

    Hi Holger,

    Thank you for the link. It has been somewhat helpful, although I am still struggling.
    How will I then alter the X axis to have set dates (month and year)? As well as having separate colour segments in one bar?

    For example, I need 5 stages (colours), which apply to every bar, but occur at different times.
    Is this possible?

    Thanks.

  4. #4
    Registered User
    Join Date
    11-30-2011
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Bar Graph/Gantt Chart

    Hi Bob,

    Separate colour segments in one bar is not a problem with a stacked bar chart.
    However automating their appearance over different times can be quite complex.
    Maybe you should go for 'conditional formatting' rather than a chart.

    Regards

    Holger

  5. #5
    Registered User
    Join Date
    11-30-2011
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Bar Graph/Gantt Chart

    Hi again,

    I quickly put a sample together based on your requirements.
    In the top section (row 4-6) you enter the stages that apply to the 3 categories for the different months.
    Below you get your colour-coded chart. All done with conditional formatting.

    Regards

    Holger

  6. #6
    Registered User
    Join Date
    11-30-2011
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Bar Graph/Gantt Chart

    The attachment...
    Attached Files Attached Files

+ 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