1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

GANTT CAHRT

Discussion in 'Discuss Data Visualizations and Charting' started by SAN04, Oct 17, 2018.

  1. SAN04

    SAN04 New Member

    Messages:
    6
    Hello,

    I have prepared a Gantt chart in excel using a stacked bar chart. The dates are on X-axis and activity bars in the plot area.

    Now I want to highlight a particular area between two dates in the chart (as working weather window) in the vertical direction.

    Please provide the suggestion.
  2. vletm

    vletm Excel Ninja

    Messages:
    4,298
    SAN04
    ... upload a sample file.
  3. SAN04

    SAN04 New Member

    Messages:
    6
    File uploaded -- I want to shadow area between Jan 2020 to Mar 2020 vertically. Also, it should change automatically if I want to move it from March to April 2020 by providing input in some other cell.

    Attached Files:

  4. SAN04

    SAN04 New Member

    Messages:
    6
    if not shadow, outline border will also work.
  5. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
  6. SAN04

    SAN04 New Member

    Messages:
    6
    Thanks Chihiro....

    I can insert two lines based on your link to capture the working window...but can we make a box and shadow it?
  7. SAN04

    SAN04 New Member

    Messages:
    6
    FILE UPLOADED WITH YOUR SUGGESTION

    Attached Files:

  8. SAN04

    SAN04 New Member

    Messages:
    6
    BUT NEED TO ADD BOX WITH SHADOW
  9. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
  10. vletm

    vletm Excel Ninja

    Messages:
    4,298
    SAN04
    ... or something like this

    Attached Files:

    Thomas Kuriakose and Chihiro like this.
  11. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
    Woo. Nice one. Didn't think of that.

Share This Page