Successful creating a Gantt Chart in Excel with uninterrupted start/stop dates as shown in the YouTube video: [url removed, login to view]).
However, I need to expand on this idea and create the same type of chart but allow interruptable dates. For example, a Task can start June 1st and stop June 10th, and then restart on July 3rd and finish on July 25th.
The deliverables for the project will consist of:
* Excel spreadsheet that can accommodate up to four (4) start/stop activities.
* VBA code (macro) that would allow me to create the chart programmatically.
Other Information: Input data for the chart is included in the attached Excel file.
NOTE - To help clarify my request I have included another attached file that shows the expected results.