Excel-Visio Gantt Chart Automation
Budget: $30 – $250 AUD
I need to automate the creation of a Gantt chart in Visio using data from Excel. The Visio chart should update automatically when the Excel data is refreshed.
The Gantt chart must include the following data from Excel and will update the Visio when the Excel data updates (and moves along the gantt chart according to the new date changes)
- Task names
- Start and end dates
- Percentage complete
- Critical tasks
Ideal skills and experience:
- Proficiency in Microsoft Excel and Visio
- Experience with linking Excel to Visio
- Knowledge of Gantt chart creation and project management tools
- Attention to detail and accuracy in data representation
Please provide examples of similar work done.
The Gantt chart must include the following data from Excel and will update the Visio when the Excel data updates (and moves along the gantt chart according to the new date changes)
- Task names
- Start and end dates
- Percentage complete
- Critical tasks
Ideal skills and experience:
- Proficiency in Microsoft Excel and Visio
- Experience with linking Excel to Visio
- Knowledge of Gantt chart creation and project management tools
- Attention to detail and accuracy in data representation
Please provide examples of similar work done.