The text box is now part of the chart box. Arranging Spreadsheet Data Beside the Chart Drag the Gantt chart to the bottom of the worksheet so it is not covering any of the rows containing data.