In Excel, it is straightforward to insert a Gantt chart or a Dynamic chart. However, ... If so, you can follow this tutorial. How to lock Chart position in Excel spreadsheet.