How to Add Resources to a Gantt Chart in Excel
- 1). Open your spreadsheet in Microsoft Excel.
- 2). Right-click the Gantt chart and choose "Select Data."
- 3). Adjust the data range in the "Chart Data Range" field. As an example, if the range currently displays "=Sheet1!$A$1:$D$4", but you added another line of data in row 5, you would change the range to "=Sheet1!$A$1:$E$5" to encompass the new data resource. You can also click the right-hand range selection square and drag your mouse across the new range.
- 4). Click "OK" to have the chart automatically adjust to accommodate the new data.
Source...