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
Plotter.xls
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
Plotter.xls
The plotter you have shown is not matching with what you have in your main sheet. Please ramify and post a correct expected output.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Plotter 1.xls
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
Posting Permissions
Reply With Quote
Bookmarks