• 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...

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

GANTT CAHRT

SAN04

Member
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.
 
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.
 

Attachments

  • Temp.xlsx
    16.5 KB · Views: 7
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?
 
Back
Top