Visual Plotter basis given dates and activity

[Rajesh Kr Joshi]

Hi,

Need code to publish a plotter basis given dates and activity. In the attached file, Main sheet contains the dates and activity and the Plotter is a visual view of main sheet.

Thanks
Rajesh
199

[Excel Fox]

The plotter you have shown is not matching with what you have in your main sheet. Please ramify and post a correct expected output.

[Rajesh Kr Joshi]

205
Hi,

I found one way to do it. First add 2 more column after each activity end date and using the weekday formula calculate the week start date for activity start week and end week. Now using the IF & And formula we can get the graphs populated. Colors can be formatted using conditional formatting.
Attached is the sheet. See if you can help with a code to hide the formula.

Thanks
Rajesh